Sunday, March 11, 2012

Backup Problem

I have a database that is around 30 gigs in size. It has always taken a
couple of hours to back up. Now all of a sudden it never stops backing
up...It started around 8:00pm last night and when I came in at 8:00am this
morning it was still backing up. There has been no major size change or
anything like that. I need to be able to back it up, but this is crazy.
I'm backing up to disk and then backing the disk file up to tape.Hi John,
First, take a look at errorlog, and NT System and application log to see if
there is any error related to the backup.
Then, Take a look at master..sysprocesses table to see if there is any
blocking problem. sp_lock output would help as well.
Sincerely,
Yih-Yoon Lee
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

No comments:

Post a Comment