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 |
|
rocking25
Starting Member
5 Posts |
 Posted - 2008-09-14 : 06:57:07
|
| I am using windows 2003 in my server and sql server 2005. we have a network which covers our four different units located within min. of 100 meters and max of 1 KM.I want to take sql server backup to a remote system. I also want to schedule backup which will place the backup file to remote sites automatically.It could be possible that everyday backup will be taken locally but weekly, monthly backup will be taken to remote site.When I starts to take backup it doesn't show the network computers. Now tell me how can I solve this problem. |
|
|
ma.voice
Starting Member
12 Posts |
Posted - 2008-09-14 : 13:38:59
|
| If you are able to connect to the remote server with necessary right then you should be able to take the backups.You can configure server spcific backup jobs on each servers. and then copy the data on network drives/sans.Better approach is to design an SSIS package with all desired configurations and deploy it with your desired schedule.Good luck.Silent VoiceBill Gates, MVP |
 |
|
|
|
|
|
Taking backup of remote system