Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Problem restoring

Author  Topic 

NeilG
Aged Yak Warrior

530 Posts

Posted - 2009-11-23 : 05:45:08
Hi Guys,

Just wondering if anyone can help me with this one.

I'm trying to restore a back from another server on to a newly created server - In SSMS i've selected to restore database - typed in the database name - selected the backup file from it's location - on the option tab i've change the location of where the files are to be restored onto - Then clicked ok

Now the MDF file is created but then for some reason no matter how long i leave the file restoring it just stops at 0 %

I've validated the file and check its not corrupt which its passed but still no joy

Is there something i'm not seeing here.

-----------------------------------------------
Learning something new on SQL Server everyday.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-23 : 10:25:34
How about trying via the RESTORE DATABASE command? You can even script the command through the GUI before you click ok to start it from there.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -