What are the challenges you face when working across database platforms? Take the survey

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.



Sign In or Register to comment.