How to backup transaction log of MASTER DB

#1

I've create a maintenance plan to backup master DB with transaction log but
il alway failed.
What is wrong?
..

#2

The error should tell you all you need to know

Server: Msg 4212, Level 16, State 1, Line 1
Cannot back up the log of the master database. Use BACKUP DATABASE instead.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

From BOL:

Note Only full database backups of master can be created.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"SST" <serge_schmit (AT) msn (DOT) com> wrote

Quote:

I've create a maintenance plan to backup master DB with transaction log
but il alway failed.
What is wrong?
.

#3

Thank's.
I've seen this today morning.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

The error should tell you all you need to know

Server: Msg 4212, Level 16, State 1, Line 1
Cannot back up the log of the master database. Use BACKUP DATABASE
instead.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

From BOL:

Note Only full database backups of master can be created.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"SST" <serge_schmit (AT) msn (DOT) com> wrote in message
news:%23Nfm$hTsEHA.820 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
I've create a maintenance plan to backup master DB with transaction log
but il alway failed.
What is wrong?
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to backup transaction log of MASTER DB

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to backup transaction log of MASTER DB - 10-13-2004 , 10:23 AM

Re: How to backup transaction log of MASTER DB - 10-13-2004 , 12:39 PM

Re: How to backup transaction log of MASTER DB - 10-14-2004 , 02:42 AM