SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Restore DB to network Mapped path
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pssumesh2003
Starting Member

India
35 Posts

Posted - 03/18/2013 :  01:10:45  Show Profile  Reply with Quote

As i Don't have enough Space in my server machine.Is it possible to restore DB to a network mapped path? i Got a link
http://www.dotnetfunda.com/articles/article1054-database-backup-to-restore-from-remote-server-sql-server.aspx

I try the steps to restore my back up in my server to a network mapped path (path is in another machine). But It executed infinitely with 0% progress on SQL server management studio. Please Guide me to restore DB to a network path.

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 03/18/2013 :  20:13:30  Show Profile  Visit russell's Homepage  Reply with Quote
The link you posted doesn't do that.

to attach a database on a network share you'll need to set trace flag 1807. This is NOT a supported configuration however.

See this link for details.

Edited by - russell on 03/18/2013 20:13:49
Go to Top of Page

prett
Posting Yak Master

USA
203 Posts

Posted - 03/20/2013 :  06:58:33  Show Profile  Visit prett's Homepage  Reply with Quote
Awesome article on restore database to network drive: http://www.mssqltips.com/sqlservertip/1126/sql-server-backup-and-restore-to-network-drive/

Hope it will solve your query!!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000