Red Gate forums :: View topic - Problem restoring database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Problem restoring database

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
psherwood



Joined: 16 Feb 2012
Posts: 4

PostPosted: Thu Feb 16, 2012 2:43 pm    Post subject: Problem restoring database Reply with quote

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.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Fri Feb 17, 2012 1:10 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group