Re: Back up system DBs
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/18/04
- Next message: Tibor Karaszi: "Re: Money Data Type"
- Previous message: Lalit: "Linked Server Timeout"
- In reply to: Niles: "Back up system DBs"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 18 Jun 2004 08:21:19 +0200
I prefer to do only db backup for master and model. For msdb, I also do log backup (because of
backup history is stored there). As Agent set msdb to simple recovery at startup, I just have a job
scheduled to autostart that set msdb to full recovery.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Niles" <Niles@discussions.microsoft.com> wrote in message news:3BE5FB23-C2DC-42CB-9572-BB7A0C7A03DF@microsoft.com... > I noticed the transaction logs for master and other system dbs can't be backed up. What are some of the practices of backing up System DBs as far as method, frequency and what type of situation would there be a need to restore from them? > Thanks
- Next message: Tibor Karaszi: "Re: Money Data Type"
- Previous message: Lalit: "Linked Server Timeout"
- In reply to: Niles: "Back up system DBs"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
