204 databases to backup

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

204 databases to backup

Postby torpenhow » Mon Aug 13, 2012 11:43 am

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
torpenhow
 
Posts: 4
Joined: Mon Aug 13, 2012 11:36 am

Postby petey » Mon Aug 13, 2012 3:21 pm

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
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 1 guest