Saturday, February 25, 2012

Restore MSDB

A quick question on MSDB and database backups:
We're moving one database to another. This database has a ton of jobs
associated with it. W're going ot be moving this database to a fresh install
of SQL Server.
My question is: if I wanted to maintain the jobs that I've created, would
just backing up MSDB and restoring it to the new box keep those jobs intact?
Would there be any issues with datqabase id's, etc. getting screwed up or ar
e
we good to go with just the restore of MSDB?
Thanks!!If you know the jobs that is associated to this database, you can generate
the SQL scripts for those jobs and run the script on the new server.
"A. Robinson" wrote:

> A quick question on MSDB and database backups:
> We're moving one database to another. This database has a ton of jobs
> associated with it. W're going ot be moving this database to a fresh insta
ll
> of SQL Server.
> My question is: if I wanted to maintain the jobs that I've created, would
> just backing up MSDB and restoring it to the new box keep those jobs intac
t?
> Would there be any issues with datqabase id's, etc. getting screwed up or
are
> we good to go with just the restore of MSDB?
> Thanks!!

No comments:

Post a Comment