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 |
|
brendita
Starting Member
38 Posts |
 Posted - 2005-12-13 : 16:54:32
|
| Quick question. Currently I am using MSDE and viewing though SQL Server using an external IP address. I was just wondering if it is possible to back up the MSDE data to a different server using a SQL Server job? |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-14 : 07:36:14
|
| Hi,yes its possible with UNC path but not recomended.:-)Regarrds.Andy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-14 : 07:43:37
|
| If you have enough disk space locally it would be more "robust" to backup to a local disk and then COPY / MOVE the resulting file to the other server. Its easy enough to create a JOB on SQL Server that will do the "Backup" and then immediately do a Command Line task to "Copy / Move" the file.Kristen |
|
|
|
brendita
Starting Member
38 Posts |
Posted - 2005-12-23 : 14:00:57
|
| Thanks Kristen! Perfect! |
|
|
|
|
|
|
backup to different server?