Home > IT Answers > SQL Server > Restoring a SQL Server 2005 database from a p...
Help

Question

  Asked: Apr 10 2008   2:35 AM GMT
  Asked by: SQL Server Ask the Experts

Restoring a SQL Server 2005 database from a public share backup


SQL Server, Backup & recovery, Disk storage, SQL Server 2005, SQL Server backup

Is it true that even in SQL Server 2005 you cannot restore a database from a backup on a public share, but ONLY from a local storage (DASD)drive?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 11 2008  7:58 PM GMT  by Mrdenny




No that is not correct. You have been able to restore from a network share as far back as SQL 7 (and probably further back). The UI (Enterprise Manager and Management Studio) will only show you the local drives on the SQL Server. However if you use the RESTORE DATABASE command you can specify a file on a network share to use for the restore.

RESTORE DATABASE MyDatabase FROM DISK='\\Server\Share\Folder\MyDatabase.bak'
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Storage.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Apr 11 2008  7:59PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.