>>>>>>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.
Ok. I will. Thank you again.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham