March 18, 2013 at 2:32 am
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
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. Is it Possible to restore a DB to network Mapped path? If yes, Please Guide me to restore DB to a network path.
March 18, 2013 at 8:24 am
do you mean backup across the network? If so yes that is possible so long as SQL is running under a domain account and you have the permissions set up correctly.
backup database yourdb to disk = '\\servername\sharename\yourdb.bak'
---------------------------------------------------------------------
March 18, 2013 at 10:09 am
Given the comment about space, I think you mean to restore the database so the data and log files are stored on a remote file share. If I guessed right then these articles may interest you:
Description of support for network database files in SQL Server
SQL Server Can Run Databases from Network Shares & NAS[/url]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply