How can we help you today? How can we help you today?
knockout
Activity overview Badges (0) Posts (3) Comments (2)

Activity overview

Latest activity by knockout

COPYTO to network share fails from time to time
  1. Community
  2. SQL Backup Previous Versions
Hi, I am using RedGate SQL Backup Pro v5.3 on SQL Server 2005 running on a Windows Server 2008 R2 x64 server with 96GB of RAM. I am seeing COPYTO failures (warning 141) every now and then. I search...
1 follower 2 comments 0 votes
Any progress made on this bug? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. COPYTO, ERASEFILES and FILEOPTIONS
Any progress made on this bug?
0 votes
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
  1. Community
  2. SQL Backup Previous Versions
  3. COPYTO, ERASEFILES and FILEOPTIONS
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
COPYTO, ERASEFILES and FILEOPTIONS
  1. Community
  2. SQL Backup Previous Versions
Hi, I backup to a drive on the primary server and use COPYTO to copy the backup to a remote network share. I also use ERASEFILES and FILEOPTIONS = 1. I have been noticing that old backup files get ...
3 followers 5 comments 0 votes
Question about ERASEFILES and MIRRORFILE
  1. Community
  2. SQL Backup Previous Versions
Hi, I had a couple of questions regarding ERASEFILES and MIRRORFILE. ERASEFILES = '7h'. Does this delete anything in the folder that is older than 7 hours when the backup starts or when the backup ...
1 follower 1 comment 0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1