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
 SQL Server Administration (2008)
 Restore DB to network Mapped path

Author  Topic 

pssumesh2003
Starting Member

35 Posts

Posted - 2013-03-18 : 01:10:45

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

5072 Posts

Posted - 2013-03-18 : 20:13:30
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.
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2013-03-20 : 06:58:33
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
   

- Advertisement -