Posts
Sort by recent activity
MOVETO error - file exists
I have a problem with the log shipping - it seems to work most of the time but we often have the situation where a log is restored and then coped to the processed log file location but not deleted ...
Log ship to different server version
Can I setup log shipping to ship from a SQL 2000 source server to a SQL 2005 destination server ?
Cheers,
Cameron
Processed log files not being deleted
When log shipping was setup, I set the option to delete processed logship files after 7 days (168 hours), but the files are not being deleted as they should be - the script for the job is below.
An...
Job ending long time after backup completed
I have several jobs on several servers backing up databases from 10MB to 4.5GB, and they all finish in times close to what standard SQL Server backup jobs do, except...
on 1 server the SQL backup t...
Backup showing as In Progress after job has finished
I have setup backup jobs on 3 different database servers to backup all user databases using maximum compression.
On each server there is 1 database that still shows up in the In Progress tab as bei...
Log restore fails
I have set up log shipping on a database with the destination set to READ ONLY so users can still query the database and run reports againats it. But if someone has a query window open in SQLEM or...