Re: Newbie ? -- Does 'master' transaction log need to be backed up?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 08:51:10 +0200

Be aware that the backup history is in the msdb database. Because of this, I also do log backup for msdb. For
some strange reason, MS decided to set msdb to simple recovery mode when agent starts, but I just fix that by
setting msdb to full in an auto-start agent job. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert" <rclay@kerrdrug.com> wrote in message news:%23sbmuX9TEHA.3140@tk2msftngp13.phx.gbl...
> Thanks, Hari.
>
> I will only backup the Transaction Logs for my user databases, then.
>
> Robert
>
>

Relevant Pages

  • Re: Back up system DBs
    ... I prefer to do only db backup for master and model. ... I also do log backup (because of ... As Agent set msdb to simple recovery at startup, ...
    (microsoft.public.sqlserver.server)
  • Re: MSDB (Subspect)
    ... I have already tried restore the msdb database from the backup but don't know why still subspected..... ...
    (microsoft.public.sqlserver.server)
  • Re: HELP! Restore DTS, Jobs, Etc.
    ... Yes - i do backup the MSDB. ... server, i needed to get things online ASAP. ... I don't think I can import the MSDB database from my "crashed" server ...
    (microsoft.public.sqlserver.server)
  • Re: What is stored in MSDB database for SQL Server 2005 Express ?
    ... Seems that the applicaton create jobs, wich are stored in msdb ... QuitWithRollback END COMMIT TRANSACTION GOTO EndSave QuitWithRollback: IF ROLLBACK TRANSACTION EndSave: ... Normally applications outside of SQL Server will never update anything in MSDB and there are much better places to store temporary files such as the file system or a user defined db or maybe even tempdb depending on what the requirements are? ... it seems that there is no reason the application has to make use of the MSDB database during database upgrade. ...
    (microsoft.public.sqlserver.server)
  • Re: Recovering Transaction Logs
    ... Backing up MSDB is always a good thing to do but it does not affect the way ... restore chain is that you usually only backup MSDB once a night. ... >> day so you don't have that many log files to recover. ... >>> t-log files to pick from, and I can easily click on the t-log that I ...
    (microsoft.public.sqlserver.programming)