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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy