Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Maintenance plan

0 views
Skip to first unread message

Peter Jensen

unread,
Nov 25, 2009, 9:51:51 AM11/25/09
to
Hi,

I have two SQL 2008 servers, on two Windows 2008 servers. I use Maintenance
Plan Wizard to backup transaction log every hour. If I use the Maintenance
Plan Wizard on one server, can I then connect to the other server, and
create maintenance plans? If yes, how? Or do I have to use the Maintenance
Plan Wizard on each server?

Andrew J. Kelly

unread,
Nov 25, 2009, 10:00:02 AM11/25/09
to
As long as you have the other server registered in SSMS you can connect to
it and do what you like.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Peter Jensen" <pete...@removemeofir.dk> wrote in message
news:ePl6T7db...@TK2MSFTNGP05.phx.gbl...

0 new messages