Options

SQL backup Never completed

SharmilarSharmilar Posts: 2
edited March 31, 2009 9:10PM in SQL Backup Previous Versions
The sql backup was running for more than 48 hours and never completed. THe backup usually completes in 30 minutes on an average and the compression rate is set to 3. The database size is around 120GB. We just patched our production server with service pack 3 on SQL server 2005.
I am not sure if this has any impact on the red gate tool.
Please advice.
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    If you run the following on the server where the backup is running:

    EXEC master..sqbutility 9997

    is there a file named SQBCoreService_bugreport.txt generated in the folder where the SQL Backup Agent service is installed? Can you send that file to me?

    If you run

    EXEC master..sqbstatus

    are there any results returned? If there are, could you run the same command again, and let me know if the values have increased?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.