Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recovering space of deleted database
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01525972
Message ID:
01525977
Views:
42
>>>>>Hi,
>>>>>
>>>>>As I am testing conversion from VFP data to SQL Server I am creating and deleting a test database in the SQL Server many, many times a day. Is there anything I should do to "pack" or recover space occupied by the deleted database?
>>>>>
>>>>>TIA.
>>>>
>>>>SQL Server will eventually reclaim the space. Just don't forget to make a frequent backups and transactional log backups.
>>>
>>>Thank you. What table/file is Transaction Log? I have never done back up of this; I only backup individual databases.
>>
>>Each database has the database file (usually with extension of mdf) and the log file (usually same name with the ldf extension).
>>
>>You need to make backups of both database and log file. Please read
>>
>>http://msdn.microsoft.com/en-us/library/ms186865.aspx
>>
>>and pay attention to BACKUP LOG command.
>
>Thank you. I will.

I wanted to tell you may want to scroll to the sample 2 in this page.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform