204 databases to backup
torpenhow
Posts: 6
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
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
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8