dbTalk Databases Forums  

Re: sql server 2005 std, maint plan for other database engines?

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools Re: sql server 2005 std, maint plan for other database engines?

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


Discuss Re: sql server 2005 std, maint plan for other database engines? in the microsoft.public.sqlserver.tools forum.



Reply
Page 1 of 5 1 2 3 4 5 >
 
Thread Tools Display Modes
  #1  
Old   
mat
 
Posts: n/a

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM





In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


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

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM





In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


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

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM


In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


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

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM


In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


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

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM


In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


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

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM


In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


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

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM


In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


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

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM


In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


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

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 12:35 AM


In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
Quote:
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


Reply With Quote
  #10  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: sql server 2005 std, maint plan for other database engines? - 10-08-2008 , 02:31 AM


Hi mat,

You can create maintenance plans for your local server or remoteserver. But
as it's mentioned in the post, there is no a connection dialog on the
Maintenance Plan Wizard to connect to remote databases.

Nevertheless, you can create this desired plan without the wizard. When you
click on the Maintenance Plans on the Object Explorer a popup menu appears.
Click "Create Maintenance Plan..." instead of the wizard. There, you'll be
able to create different connections so that remote server databases will be
reachable. Also, this is a more flexible way of creating richer and more
functional plans.

--
Ekrem Önsoy




"mat" <mat (AT) notarealdotcom (DOT) adr> wrote

Quote:
In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>,
mat (AT) notarealdotcom (DOT) adr says...
I had sql server 2005 std installed on server A and wanted to describe a
maint plan that included backup etc for sql server 2005 express
databases on server b. My first efforts failed with an error at the very
end of the wizard, and my research led me to believe that installing sp2
for sql 2005 would fix that error. But now I can't seem to create a
maint plan for any sql server other than the one I just installed on
server a. I'm able to connect to the sql server installation on server
b, but nowhere in the wizard is there an option to choose which sql
server instance to use, only which db to include in the plan. Can anyone
tell me what's going on with this?

Hope this is the right forum to post this too?

Can someone comment on this?


Reply With Quote
Reply
Page 1 of 5 1 2 3 4 5 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top