|
Home > Archive > MS SQL Server > November 2005 > Transaction Log Backups
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transaction Log Backups
|
|
| Elecia 2005-11-30, 8:23 pm |
| 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
| |
| Kevin3NF 2005-11-30, 8:23 pm |
| Just 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
| |
| Geoff N. Hiten 2005-11-30, 8:23 pm |
| Neither. 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
|
|
|
|
|