Restore DB to network Mapped path

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.

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!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources