Compresses, encrypts, secures and monitors SQL Server backups.
Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey
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.
- Posts: 4
- Joined: Mon Aug 13, 2012 11:36 am
There are some alternatives to explicitly naming each and every database that needs to be backed up. See this post
SQL Backup Consultant Developer
Associate, Yohz Software
- SQL Backup goodies under the hood, updated for version 7
- Posts: 2227
- Joined: Sun Apr 24, 2005 12:34 pm
Return to SQL Backup 7
Who is online
Users browsing this forum: No registered users and 0 guests