backup question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 03 Oct 2005 12:17 GMT

Dear all,
i want to verify whether the following backup planning can restore to the
original environment or not
1.) backup master, msdb, model with full backup to bak
2.) backup all user database with full backup and tran log backup to bak

question
how about the DTS package, user login, replication, job schelding, is it can
restore when i backup to the master and model?

Reply to this Message

Sue Hoegemeier - 03 Oct 2005 13:01 GMT

Users, packages and jobs are all in the databases you are
backup up (DTS Packages - as long as they are saved to SQL
Server as the location) so backing up all of your databases
and restoring all databases, including system databases will
get things back.
Replication restore strategies depend on how you have
implemented replication. You'd want to backup the publisher,
distributor, subscriber. There are different strategies for
merge, transactional, snapshot replication. You can find
them in books online. Look up the index topic:
replication, backup and restore operations

-Sue

>Dear all,
>i want to verify whether the following backup planning can restore to the
[quoted text clipped - 5 lines]
>how about the DTS package, user login, replication, job schelding, is it can
>restore when i backup to the master and model?

Reply to this Message