Re: What databases should be backed up daily
From: Uri Dimant (urid_at_iscar.co.il)
Date: Wed, 10 Nov 2004 16:59:25 +0200
No, don't mix them ,bishvil ma?
Create a folder like system_back and store it there.
Moreover , I'd be separate master from others system databases.
"Boaz Ben-Porat" <email@example.com> wrote in message
> Hi Uri, Toda raba
> About question 1: Is there any reason whay the Master and Msdb databases
> should NOT be backed up in the same maintenance plan as user-databases ?
> The backup creates a separate .BAK file for each database.
> Boaz Ben-Porat
> "Uri Dimant" <firstname.lastname@example.org> wrote in message
> > Boaz, shalom
> > 1) No, it should be separated. This allows the system to be rebuilt in
> > event of system or database failure, for example, if a hard disk
> > fails.Remember that only Full backup is allowed with master db
> > 2) Yes, along with master database , you should backup msdb as well.
> > Backup
> > distribution database server is configured as a Replication Distributor.
> > Regarding model database , i don't think it is necessary unless your
> > model
> > database is customized.
> > "Boaz Ben-Porat" <email@example.com> wrote in message
> > news:uWiIFFzxEHA.firstname.lastname@example.org...
> >> Hi all
> >> I have to create a simple Maintenance Plan to backup all user
> >> I
> >> heard somewhere that the Master database should also be backed up.
> >> Question 1) Should Master database also be backed up together with
> >> user-databases?
> >> Question 2) Are there other system databases that should backed up
> > together
> >> with user-databases?
> >> TIA
> >> Boaz Ben-Porat
> >> Milestone Systems