Comments
Sort by recent activity
That sound like the problem.
I'll post on Monday with my results.
Again, thanks for the help. / comments
That sound like the problem.
I'll post on Monday with my results.
Again, thanks for the help.
Our normal SQL Server backup was running at 21:30 (just while we were testing SQL Backup), would this mess things up?
I've disabled this now, so I'll monitor it over the weekend and see if we can restore the backups on Monday (7th Nov).
Thanks for the help / comments
Our normal SQL Server backup was running at 21:30 (just while we were testing SQL Backup), would this mess things up?
I've disabled this now, so I'll monitor it over the weekend and see if we can r...
The error I'm getting is as follows :
11/4/2005 10:12:23 AM: Restoring file: E:\Microsoft SQL Server\MSSQL\BACKUP\DIFF_(local)_metadata_20051031 165735.sqb
11/4/2005 10:12:23 AM: Restore started ...
SQL Server messages
Msg 3136, Level 16, State 1, Server VIRGINMEGAUK57, Line 1
Cannot apply the backup on device 'SQLBACKUP_9637485' to database 'metadata'.
Msg 3013, Level 16, State 1, Server VIRGINMEGAUK57, Line 1
RESTORE DATABASE is terminating abnormally.
I think I may be doing something wrong in the backup process. Do I need to have 1 job for the full backup and 6 seperate jobs for the differential backups all going to different files? At the moment I have 1 job for the full backup and 1 job for the differential backup that runs every night (except Saturday when the full backup is run) going to the same file.
Any help gratefully accepted / comments
The error I'm getting is as follows :
11/4/2005 10:12:23 AM: Restoring file: E:\Microsoft SQL Server\MSSQL\BACKUP\DIFF_(local)_metadata_20051031 165735.sqb
11/4/2005 10:12:23 AM: Restore started .....