Log Ship CopyTo function failed silently

Forum for users of Redgate's SQL Backup tool

Postby shu lee » Fri Apr 05, 2013 11:36 pm

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

Postby petey » Sun Apr 07, 2013 8: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 8
Posts: 2357
Joined: Sun Apr 24, 2005 11:34 am


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests