November 21, 2011 at 5:07 pm
I have a 243gb database. The Red Gate backup of the database is 53gb. I am restoring the database from that backup. The restore appears to complete successfully but it only takes 21 seconds.
I ran RESTORE VERIFYONLY against the backup. It was successful and took about 15 minutes to complete.
I also ran the following query (with the actual db name.) It reports the last restore as several days ago - not today.
SELECT TOP 1 *
FROM RESTOREHISTORY WITH (nolock)
WHERE (DESTINATION_DATABASE_NAME = 'xxxxxxxxxx')
ORDER BY RESTORE_DATE DESC
Anyone have any ideas? Why would the restore report success when it does not seem to be working and completing so quickly? Thanks!
November 21, 2011 at 5:44 pm
Never mind. I was running the restore as a job step. The job was reporting success but the restore was failing because it could not get exclusive use of the DB. The restore is running as it should now.
November 21, 2011 at 6:23 pm
Ah ok, my first answer just from the header was how the heck can that possbily be a problem :-D.
Thanks for the feedback.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply