Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Transaction Log BackupsHi All, Can anyone tell me whether backing up the transaction logs for the master database is the equivalent of backing up the transaction logs for all the db's on that server or is it strictly backing up the transactions for the master db? Thanks in advance, -- Elecia
Post Follow-up to this message
Re: Transaction Log BackupsJust the master...each DB has its own t-logs that need to be backed up separately (or not, depending on if you are in Simple recovery mode for the db in question) -- Kevin Hill President 3NF Consulting www.3nf-inc.com/NewsGroups.htm "Elecia" <Elecia@discussions.microsoft.com> wrote in message news:D9C1B287-95DC-46D2-93BE- 650D64C1E918@microso ft.com... > Hi All, > Can anyone tell me whether backing up the transaction logs for the master > database is the equivalent of backing up the transaction logs for all the > db's on that server or is it strictly backing up the transactions for the > master db? > Thanks in advance, > -- > Elecia
Post Follow-up to this message Re: Transaction Log BackupsNeither. Master is always in SIMPLE recovery mode. As such, you cannot back up the transaction log. tempdb, model, and msdb are the also always in SIMPLE recovery. You can put msdb into FULL recovery, but it will reset to SIMPLE next time you restart SQL Server. The master database contains server metadata, that is data about the data. Precisely, it contains information about the server configuration itself, all login information, information about where to find user databases, extended stored procedure information, and a boatload of system stored procedures. Before one or more of my colleagues jumps in, I am sure I left stuff off the list, but you get the idea. Therefore, when you back up master, you are backing up part of the SQL Server configuration. You will still need to perform backups on the user databases. -- Geoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Elecia" <Elecia@discussions.microsoft.com> wrote in message news:D9C1B287-95DC-46D2-93BE- 650D64C1E918@microso ft.com... > Hi All, > Can anyone tell me whether backing up the transaction logs for the master > database is the equivalent of backing up the transaction logs for all the > db's on that server or is it strictly backing up the transactions for the > master db? > Thanks in advance, > -- > Elecia
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
