How can we help you today? How can we help you today?

204 databases to backup

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
0

Comments

1 comment

Sort by
  • petey
    There are some alternatives to explicitly naming each and every database that needs to be backed up. See this post for details.
    petey
    0

Add comment

Please sign in to leave a comment.