SQL Server Performance Forum – Threads Archive

SQL Backup problem

I have a weird problem with my backups that I cannot resolve. The backup jobs appear to run correctly (according to the history), but when the database is restored and compared against the original, the data is old. The date on the files indicates that the backup job ran. This is the code used to backup the database: IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = ‘Docuware’)
BEGIN
BACKUP DATABASE Docuware TO DISK = ‘D:BACKUPDocuware.bu’
WITH INIT, NAME = ‘Docuware_BU’, SKIP
RESTORE VERIFYONLY FROM DISK = ‘D:BACKUPDocuware.bu’
END Any insight would be greatly appreciated

no idea what the problem would be, but have you tried running the script from QA? Does it work as expected if run from there? Ben ‘I reject your reality and substitute my own’ – Adam Savage

True, I would seperate the jobs of backup and restore in order to ensure the jobs execution. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>