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.
| Author |
Topic |
|
paramu
Posting Yak Master
151 Posts |
 Posted - 2012-03-24 : 10:14:24
|
Hi,Thanks. How to handle a Backup - Restore from a LAN Netwok- sql server? My sql server is in my network. Whenever I want to take backup & Save the backup in same server [C-Drive or D-Drive] its working fine... But I want to take backup from my server and wish to save that backup file in my system, which is available in same network., For that any right direction will be helpful. Comments Iam using ------------------------- backup database MyDatabase to disk='D:\Check\MyDtb1.bak' simillarly, restore database MyDatabase from disk='D:\Check\MyDtb1.bak' Thanks for the helps Paramu @ PARANTHAMAN |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2012-03-24 : 13:29:44
|
You can backup to a UNC path. backup database MyDatabase to disk = '\\yourFileServer\yak\mydatabase.bak' with init Are you having problems with this approach? The svc account will of course need access to that network share. Another approach is to map a drive.Nathan Skerl |
 |
|
|
|
|
|
SQL Server 2008 - Backup & Restore on Lan Netwrok?