dbTalk Databases Forums  

SQL Maintenance Plan and Server Agent Jobs

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL Maintenance Plan and Server Agent Jobs in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Greg
 
Posts: n/a

Default SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:18 PM






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

Reply With Quote
  #2  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM






Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
  #3  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM



Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
  #4  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM



Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
  #5  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM



Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
  #6  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM



Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
  #7  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM



Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
  #8  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM



Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
  #9  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM



Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
  #10  
Old   
Greg
 
Posts: n/a

Default RE: SQL Maintenance Plan and Server Agent Jobs - 11-17-2008 , 01:31 PM



Although I'd still like to understand why I got the errors I got, I was able
to delete both items after all. I just don't understand why I am getting
errors doing a Delete function on a job. Thanks.

"Greg" wrote:

Quote:
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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.