Problem restoring database

Forum for users of Redgate's SQL Backup tool

Problem restoring database

Postby psherwood » Thu Feb 16, 2012 2:43 pm

I have a database backup that is in 5 sqb files. I'm trying to restore it to a new server and it has been running for 15 hours. I notice that the server icon shows a red x every now and then and when I check it it says it timed out. It always reconnects after that.

Is this restore stuck? Do I need to cancel it and start it again? The database is around 25Gb and the progress has been stuck on 16.8Gb for the last 12 hours.
psherwood
 
Posts: 4
Joined: Thu Feb 16, 2012 2:40 pm

Postby petey » Fri Feb 17, 2012 1:10 am

Could you please generate a stack trace (see here of the hanging process, and post the contents?

Also, what version of the SQL Backup Agent are you using? Please note that this is not the GUI, but the Agent (SQBCoreService.exe) that is running on your server.

Lastly, could you please check the SQL Server error log and also the Windows Event log (source = SQLVDI) for any errors that may be related to the restore?

Thanks.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2301
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests