SQL Backup 6?

Forum for users of Redgate's SQL Backup tool

SQL Backup 6?

Postby aaditya2000 » Fri Nov 16, 2012 1:45 am


we are using SQL Backup 6.0 on our SQL Server 2008 which is on latest service pack (10.0.5500).

intermitently i am seeing that my backups are failing & i am seeing long wait_type "PREEMPTIVE_OS_GETPROCADDRESS".

The way it get resolve is by restarting SQL Server Services & sometime rebooting server.

Does someone has experience this issue & is there any fix from RedGate?

Any help is greatly appreciated.

Posts: 4
Joined: Fri May 04, 2012 5:59 pm

Postby petey » Mon Nov 19, 2012 5:20 am

If possible, try upgrading to 6.5, as it resolves a bunch of issues since the 6.0 release. See here for details. This list is not exhaustive as there were other fixes made in 6.1 to 6.4 too.

If you would like to continue using 6.0, we need to determine the cause of the error. When SQL Backup encounters a critical error, it generates a stack trace of events leading up to the error. This stack trace is then stored in a file named SQBCoreService_<instance name>_bugreport.txt, and is located in 'C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Log\\' on Windows 2003 and older, and 'C:\\ProgramData\\Red Gate\\SQL Backup\\Log\\' on Windows Vista and newer.

Could you please check if that file exists on your system? If it does, could you please send it to us? If the file does not exist, it may be because the SQL Backup Agent service startup account does not have rights to create the file in that folder. You can test this by manually creating the stack trace file by running the following command from Query Analyzer/Management Studio when connected to the SQL Server instance:

EXEC master..sqbutility 9997

If the file is not created, try granting read/write permissions on the abovementioned folder to the SQL Backup Agent service startup account.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Posts: 2357
Joined: Sun Apr 24, 2005 11:34 am

Postby aaditya2000 » Wed Nov 28, 2012 9:23 pm

Thanks for your reply, will do.
Posts: 4
Joined: Fri May 04, 2012 5:59 pm

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests