Viewing 7 posts - 16 through 22 (of 22 total)
Go to the error log directory and check error log using a text editor.
Alan
September 21, 2011 at 8:44 pm
Hi Jeff,
Same as you I am the strong opponent against the log truncation and file shrinking. For my situation it was the external backup program and maintenance cleanup task competing...
August 7, 2011 at 7:08 pm
It is so awkward you need to restart the SQL server to kill the stuck backup rollback. I had similar problem when my maintenance job (does the backup) got stuck...
August 7, 2011 at 5:57 pm
I too learnt this the hard way. I was once troubleshooting a SQL 2000 prod server performance problem with too much context switching. Without knowing the consequence, I decided to...
May 1, 2011 at 9:06 pm
Hi Manu,
We have finally managed to remove the sec log file by changing the database into single user mode. Backup log, Shrinkfile with empty switch.
So the trick is the single...
June 12, 2008 at 5:28 pm
Thanks Manu,
Does the log file sequence number for the secondary log file I want to empty need to be the last?
The reason I am asking is everytime after I...
June 10, 2008 at 5:23 pm
Hi,
Look like you can take your database offline. If this is the case then the quickest way will be detach database (do a full backup before this) and then attach...
June 9, 2008 at 7:26 pm
Viewing 7 posts - 16 through 22 (of 22 total)