Re: MSDB database
From: ch (ch_at_dontemailme.com)
Date: 02/18/04
- Next message: anonymous_at_discussions.microsoft.com: "new sql login using active directory"
- Previous message: tradmusic: "what is MSSQL NEWID() in Access?"
- In reply to: Aaron Bertrand - MVP: "Re: MSDB database"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Feb 2004 10:05:17 -0600
Aaron Bertrand - MVP wrote:
> > anyone has any ideas why/what process, etc. would reset the recovery
> option
> > from FULL to SIMPLE?
>
> This is the way SQL Server works.
> http://www.support.microsoft.com/?id=257856
>
that link is interesting. sort of contradicts the line from BOL "All recovery
models are supported for model, msdb and distribution." since full recovery on
msdb only works until sqlagent is restarted.
i always prefer to have a dbmp for user databases and one for system databases.
in the system one, i don't back up transaction logs.
i think it's sort of goofy that the transaction log backup from a dbmp will try
to backup the logs for db's in simple recovery and then generate errors. i've
written a script that skips simple recovery db's for the log backups, why can't
microsoft implement it in the dbmp jobs?
- Next message: anonymous_at_discussions.microsoft.com: "new sql login using active directory"
- Previous message: tradmusic: "what is MSSQL NEWID() in Access?"
- In reply to: Aaron Bertrand - MVP: "Re: MSDB database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
