1

You can use the DBCC shrinkfile command to shrink the transaction log.

do you have backup of the MSDB database?

Use the intructions in BOL for restoring a system database

If none of the above solutions work for you, you can delete the log file by detaching the database, renaming the log file and then reattaching the database without the...

Hi Chris,

Depending on how your hardware if configured I don't think changing the recovery model will have too much impact on the performacne of your DB. You will need to...

I have a university degree, a Master degree, MCDBA and MCITP certifications. All gained in this millennium, anyone got a job?