Limit on number of databases per Instance

Forum for users of Redgate's SQL Backup tool

Limit on number of databases per Instance

Postby tknoob » Mon Dec 17, 2012 5:53 pm


Is there a limit on the number of databases to backup per Instance?

We have over 1400 databases in an Instance and the backups hang after a period of time. Using v7.2.1.4.


Tim Knoob
Senior Database Administrator
Posts: 6
Joined: Wed Jun 07, 2006 10:54 pm

Postby petey » Wed Dec 19, 2012 1:54 am

There isn't a limit to the number of databases that SQL Backup can back up per instance, since each database is backed up sequentially.

SQL Backup should have generated a log file if it crashed. Could you please send me this file? This file is 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.

- output from sp_who2 if the backup is still in a hanging state

- the SQL Backup backup command that you were using

- any errors recorded in the Windows Event log related to the SQLVDI source during the time of the backup

- any errors recorded in the SQL Server error log during the time of the backup

Thank you.
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

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests