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 |
|
hissein
Starting Member
5 Posts |
 Posted - 2012-08-02 : 22:56:46
|
| Hey guys, Im new in SQL server, Need you advise on SQL script to do a full database backup to a different server where the database is saved. for example: Database Server IP Address = "10.1.2.1"Destination Server IP Address = "10.1.2.34"Can the saving be done on in C drive folder? does it reques any form of authentication?Thanks |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-08-03 : 13:56:31
|
| The service account running SQL Server on the source system will need access to a shared folder on the destination system. Once that is set up, you can use the UNC path in the backup:BACKUP DATABASE {database} DISK='\\uncpath\share\folder\backup_file.bak';Note: backing up across the network can be problematic and may fail if the network has any latency. It is generally a better method to backup locally and copy the file to the other server. |
 |
|
|
hissein
Starting Member
5 Posts |
Posted - 2012-08-05 : 21:27:29
|
| Thanks for your reply. What are the steps i can perform from SQL server to create Shared folder? |
|
|
|
|
|
|
Database Backup to a different Server