204 databases to backup

torpenhow

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

petey

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