Log Ship CopyTo function failed silently

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Postby shu lee » Sat Apr 06, 2013 12:36 am

What does the status = 'p' means?
shu lee
 
Posts: 9
Joined: Tue Apr 02, 2013 4:40 am

Postby petey » Sun Apr 07, 2013 9:36 am

'P' means pending. It looks like at any one point, there are 2300+ files waiting to be copied, and is probably increasing over time as more files get queued, and SQL Backup isn't copying them over fast enough. Since SQL Backup will copy older files first, this explains why the new backup files are only getting copied almost 24 hours later.

If you look at the files that have already been copied (with a status of 'S'), how long does it take on average to copy a single file?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2228
Joined: Sun Apr 24, 2005 12:34 pm

Previous

Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests