>>Someone has asked me a question about backups and it has been too long since I have worked with MSSql. He has an application that has about 50 databases and there is a script that runs every night to back everything up except, he has not been truncating the logs. No they are about to run out of disk space and need to recover most of the space used by the logs. Here one line of the script he is using now.
>>
>>

>>BACKUP DATABASE DATABASE_1 TO DISK = 'd:\SQLBACKUP_day1\DATABASE_1.bak' With INIT
>>

>>
>>It is my understanding that "truncate log" does not shrink the file. How can I automate the shrink file as well?
>
>I use something like this:
>
>

>Alter Database MyDatabase Set Recovery Simple
>
>Use MyDatabase
>
>DBCC ShrinkFile (MyDatabase_Log,1)
>

Hi Michel,

I had read somewhere recently that shrinkfile was a bad idea. Have you had any problems with it?