Red Gate forums :: View topic - Limit on number of databases per Instance
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Limit on number of databases per Instance

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tknoob



Joined: 07 Jun 2006
Posts: 6

PostPosted: Mon Dec 17, 2012 6:53 pm    Post subject: Limit on number of databases per Instance Reply with quote

Hi,

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.

Thanks.

Tim Knoob
Senior Database Administrator
Kareo
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Wed Dec 19, 2012 2:54 am    Post subject: Reply with quote

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 7
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group