Red Gate forums :: View topic - 204 databases to backup
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

204 databases to backup

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



Joined: 13 Aug 2012
Posts: 4

PostPosted: Mon Aug 13, 2012 11:43 am    Post subject: 204 databases to backup Reply with quote

I have many databases on the same server to backup but the script SQL Backup creates is too long currectly about 4533 characters. Message:-

The specified @command is too long. It must contain no more than 3200 characters.

Is there some way that I can increase the length of the @command variable. We are adding databases here quite often so would like to change the length to 5000 characters.

Regards
Carolyn
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Mon Aug 13, 2012 3:21 pm    Post subject: Reply with quote

There are some alternatives to explicitly naming each and every database that needs to be backed up. See this post for details.
_________________
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