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 |
|
martha
Starting Member
1 Post |
 Posted - 2005-12-24 : 10:01:02
|
Hi, I am new on sql and very happy finding your forum!Ive just installed mssql 2005 on my pc and I need your help on backing up a database that is on a remote server.I ve connected to the remote server using the Management Studio. Im accessing the database and Im getting the backup, but unfortunately I see that the back up is being saved on the remote server. How can I backup the database saving it on my machine? Thanks in advance,Martha |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-12-24 : 11:06:19
|
| I usually backup to a file localy (to the source server), copy/move the file to the target (restore server), then restore from the (now local) file. So the Backup and restore operations are always local to the server.Be One with the OptimizerTG |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-26 : 00:09:54
|
| or Use \\sysName\DriveName$\fileName when taking backupMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Backup from remote server