I recently restored 3 databases. The maintenance plans responsible for
creating the backups for those databases appear to have disappeared after th
e
restoration. I deleted the databases prior to restoration, but did not touc
h
the plans.
Is there a way to make sure that the next time I have to restore the
databases that the plans do not get removed? Is there a way to backup or
export the maintenance plans?
Thanks
MarkDid you restore msdb? Or did you perform a rebuild of the system databases?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Coffman" <MarkCoffman@.discussions.microsoft.com> wrote in message
news:970287BA-384C-49A8-BA53-26E1BE124F57@.microsoft.com...
>I recently restored 3 databases. The maintenance plans responsible for
> creating the backups for those databases appear to have disappeared after
the
> restoration. I deleted the databases prior to restoration, but did not to
uch
> the plans.
> Is there a way to make sure that the next time I have to restore the
> databases that the plans do not get removed? Is there a way to backup or
> export the maintenance plans?
> Thanks
> Mark
>
Wednesday, March 7, 2012
Maintenance Plans Disappear
Labels:
appear,
backups,
database,
databases,
disappear,
disappeared,
forcreating,
maintenance,
microsoft,
mysql,
oracle,
plans,
responsible,
restored,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment