Re: backup question
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/03/05
- Previous message: Marcin Okraska: "User authentication problem when accesing ReportServer- very strange"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 03 Oct 2005 06:01:35 -0600
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
On Mon, 3 Oct 2005 04:17:13 -0700, Joe
<Joe@discussions.microsoft.com> wrote:
>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?
- Previous message: Marcin Okraska: "User authentication problem when accesing ReportServer- very strange"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
