| Author |
Message |
torpenhow
Joined: 13 Aug 2012
Posts: 4
|
 Posted: Mon Aug 13, 2012 11:43 am Post subject: 204 databases to backup |
 |
|
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 |
|
 |
petey
Joined: 24 Apr 2005
Posts: 2219
|
| Posted: Mon Aug 13, 2012 3:21 pm Post subject: |
|
|
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 |
|
|
|
|
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
