How can we help you today? How can we help you today?
knockout
I've enclosed part of the log file generated for a sample backup if it helps: 9/22/2009 6:00:00 PM: BACKUP DATABASE [dbname] TO DISK = '<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', DIFFERENTIAL, INIT, ERASEFILES = 12h, COPYTO = '\\remote\E$\Backup\server\dbname', FILEOPTIONS = 1, COMPRESSION = 2 9/22/2009 6:03:11 PM: Backup data size : 3.755 GB 9/22/2009 6:03:11 PM: Compressed data size: 938.851 MB 9/22/2009 6:03:11 PM: Compression rate : 75.58% Processed 147232 pages for database 'dbname', file 'filename' on file 1. BACKUP DATABASE WITH DIFFERENTIAL successfully processed 491971 pages in 188.717 seconds (21.355 MB/sec). 9/22/2009 6:03:11 PM: Deleting old backup file: [image] \Backup\server\dbname\dbname_DIFF_20090921_180000.sqb 9/22/2009 6:03:11 PM:Deleting old backup file: \\remote\E$\Backup\server\dbname\dbname_DIFF_20090921_180000.sqb 9/22/2009 6:03:39 PM: Copied [image] \Backup\server\dbname\dbname_DIFF_20090922_180000.sqb to \\remote\E$\Backup\server\dbname\dbname_DIFF_20090922_180000.sqb. 9/22/2009 6:03:39 PM: SQL Backup process ended. 9/22/2009 6:03:39 PM: Deleted msdb entries older than 8/23/2009 6:03:39 PM 9/22/2009 6:03:39 PM: Deleted local history entries older than 8/23/2009 6:03:39 PM / comments
I've enclosed part of the log file generated for a sample backup if it helps: 9/22/2009 6:00:00 PM: BACKUP DATABASE [dbname] TO DISK = '<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', DIFFER...
0 votes