Activity overview
Latest activity by gsabowen
petey wrote:
Does the backup start if you run it manually using the command generated by the script?
Yes it does. / comments
petey wrote:
Does the backup start if you run it manually using the command generated by the script?
Yes it does.
-SQL "BACKUP DATABASE [ITIServer] TO DISK = '\\SomeServer\backup\mssql\Daily\db\SomeDirectory\ITIServer_Full.sqb' WITH NAME = 'ITIServer( Full Backup )', PASSWORD = '12345',
DESCRIPTION = 'Full Backup At Oct 27 2005 8:21AM', INIT, VERIFY,
MAILTO_ONERROR = 'SomeOne@Somewhere.com', COMPRESSION = 2" -E
-SQL "BACKUP DATABASE [msdb] TO DISK = '\\SomeServer\backup\mssql\Daily\db\SomeDirectory\msdb_Full.sqb' WITH NAME = 'msdb( Full Backup )', PASSWORD = '12345',
DESCRIPTION = 'Full Backup At Oct 27 2005 8:21AM', INIT, VERIFY,
MAILTO_ONERROR = 'SomeOne@Somewhere.com', COMPRESSION = 2" -E
-SQL "BACKUP DATABASE [PDS1751] TO DISK = '\\SomeServer\backup\mssql\Daily\db\SomeDirectory\PDS1751_Full.sqb' WITH NAME = 'PDS1751( Full Backup )', PASSWORD = '12345',
DESCRIPTION = 'Full Backup At Oct 27 2005 8:21AM', INIT, VERIFY,
MAILTO_ONERROR = 'SomeOne@Somewhere.com', COMPRESSION = 2" -E / comments
-SQL "BACKUP DATABASE [ITIServer] TO DISK = '\\SomeServer\backup\mssql\Daily\db\SomeDirectory\ITIServer_Full.sqb' WITH NAME = 'ITIServer( Full Backup )', PASSWORD = '12345',
DESCRIPTION = 'Full Bac...
Backup being skipped
I have a SP that performs a Full backup once a week on Saturday and Differential backups the other six days. It works fine on three servers but is skipping a large DB on one server. No email is p...