204 databases to backup

Forum for users of Redgate's SQL Backup tool

204 databases to backup

Postby torpenhow » Mon Aug 13, 2012 10: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.

Posts: 4
Joined: Mon Aug 13, 2012 10:36 am

Postby petey » Mon Aug 13, 2012 2: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 8
Posts: 2357
Joined: Sun Apr 24, 2005 11:34 am

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests