Virtual Centre SQL 2005 Log File.

[Willie_Ekerslik]

We currently do not have the virtualcentre ldf file in our backup routine and consequently the file has grown to fairly large proportions. Before we include it in the backup strategy will it cause any problems if we back it up and dbcc shrinkfile it to reduce the physical size?

Cheers.

[Dave_Mishchenko]

It won't be an issue to backup the transaction log and then shrink the log file. Is it important to backup the transaction log file for your VC database - i.e. would you be happy with a full daily backup? If so I would just set the DB to simple recovery mode. If you were only going to run transaction log backup once per day, then it would be better to switch the db to simple recovery and eliminate the need to backup the log.