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 2008 Forums
 Other SQL Server 2008 Topics
 can't restore sql 2012 backup

Author  Topic 

tracy5436
Yak Posting Veteran

50 Posts

Posted - 2012-09-03 : 18:09:13
Hi,

I am trying to restore a sql 2012 backup from another instance. When I select to restore from a backup device and then point to the file, the database drop-down is blank so I cannot select the database to restore. This database is from a sql 2012 32-bit install and I am trying to restore to a 64-bit instance.

I have also tried creating the backup device before but with the same result.

Help !

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-09-04 : 01:34:24
Just to clarify - are you trying to RESTORE a .bak from the local server or a remote server?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-04 : 14:23:22
Use the RESTORE command and a UNC path.

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -