>>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.
"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