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 |
|
Kirun
Yak Posting Veteran
60 Posts |
 Posted - 2010-04-13 : 06:10:55
|
| I want to take the backup of my SQL Server 2005 databases to a remote share for more security of the data. But the system wont let me do that. Can any body have the way to take backup on another remote computer within the domain.Please help |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-04-13 : 06:27:00
|
Have you tried this:BACKUP DATABASE myDB TO DISK='\\servername\path\myDB.bak' WITH INIT Be advised that backing up directly to a network share may corrupt the backup file if there is any kind of network issue, even minor hiccups. It is much safer to back up a database to a local disk, then copy the backup file to the remote server. |
 |
|
|
|
|
|
How do i take backup of Database on remote Share