I asked my dba in training to make a backup of a large database using dbo.DatabaseBackup and he said it was taking a long time and he wanted to know how to add "stats = 5". I said without checking "add @stats = 5" thus having
use dba
go
exec dbo.DatabaseBackup
@databases = 'dba',
@directory = 'd:\backups\',
@BackupType = 'full',
@init = 'y',
@stats = 5
But of course this did not work. I looked at the code and this easy-to-support functionality does not exist. I would be happy to add it as part of a community coding effort.
I asked my dba in training to make a backup of a large database using dbo.DatabaseBackup and he said it was taking a long time and he wanted to know how to add "stats = 5". I said without checking "add @stats = 5" thus having
But of course this did not work. I looked at the code and this easy-to-support functionality does not exist. I would be happy to add it as part of a community coding effort.
Thanks, John