Competition: What’s your favorite Redgate tool? Enter now.

204 databases to backup

torpenhowtorpenhow Posts: 6
edited August 13, 2012 10:21AM in SQL Backup Previous Versions
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

Comments

Sign In or Register to comment.