![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
#3
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
#4
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
#5
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
#6
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
#7
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
#8
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
#9
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
#10
| |||
| |||
|
|
I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of my databases to the same server. So, what i've done is setup the jobs to all run from my main server, which appears to run fine. What I haven't been able to figure out though is how to get all of my Backup Maintenance Plans to backup to my main server, rather than the server they are on. When selecting a Backup Destination I can only select drives on the current server, not my main server. I've also mapped my main server to the other server and that's not available either. It seems I can do this at all. Is this true? I know if need be, I could write a script and add it to my routines to handle the process of moving the backup from one server to another after the backup. I just would like to know if there's an easier way. Anyone's help is greatly appreciated. Thanks, Greg |
![]() |
| Thread Tools | |
| Display Modes | |
| |