 |
|
|
|
Next: Stored Procedure
|
| Author |
Message |
External
Since: Jan 26, 2008
Posts: 17
|
(Msg. 1) Posted: Mon Nov 17, 2008 11:18 am
Post subject: SQL Maintenance Plan and Server Agent Jobs
Archived from groups: microsoft>public>sqlserver>tools (more info?)
|
|
|
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 |
|
| Back to top |
|
 | |
External
Since: Jan 26, 2008
Posts: 17
|
(Msg. 2) Posted: Mon Nov 17, 2008 11:31 am
Post subject: RE: SQL Maintenance Plan and Server Agent Jobs [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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:
> 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 |
|
| Back to top |
|
| |
External
Since: Jan 10, 2008
Posts: 211
|
(Msg. 3) Posted: Tue Nov 18, 2008 3:25 am
Post subject: Re: SQL Maintenance Plan and Server Agent Jobs [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
This is by design if you use Maintanence Wizard. However, if you use
Maintanence Plan instead of the Wizard, then you can create new connections
to other servers.
--
Ekrem Önsoy
"Greg" wrote in message
>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 >> Stay informed about: SQL Maintenance Plan and Server Agent Jobs |
|
| Back to top |
|
| |
| Related Topics: | Optimization Failure in a Maintenance Plan - Hi, We are getting a failure on a Optimization Job for a DB Maintenance Plan. The event log states a 208 error with the Job Engine. The Job History is: The job failed. The Job was invoked by Schedule 88 (Schedule 1). The last step to run was step 1..
Error with simple maintenance plan - Team; I've been getting nothing but errors recently; as I've been usign maintenance plans. Here is one of the error logs. Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'',N'',N'2008-03-14T00:56:18' " failed with the following err...
changing maintenance plan connections - Is there a less time consuming way to change the connections used in SQL maintenance tasks other than plodding through the GUI of the Server Management Studio (find plan, modify, then manage connections, then select, then edit, then save). I have a..
Maintenance Plan Log time stamps - I have a simple Maintenance Plan, it does the integrity check and then a Backup. The Log reads as follows: Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'ServerA' as 'DOMAIN\ADMINUSER' (trusted) Starting maintenance plan..
Maintenance and Impersonation? - My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save a full backup to a local disk. There is a new need for the server to copy the full backup .bak file to ... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
