backup the transaction logs is grayed out. How do I set up
a seperate backup for the T-Logs after I have set up
backup jobs for the data?Most probable reason is that the database is in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ray Ellers" <rellers@.flexiblesystems.com> wrote in message
news:40bf01c3aac7$6000b9e0$a601280a@.phx.gbl...
> When setting up a backup of the database the option to
> backup the transaction logs is grayed out. How do I set up
> a seperate backup for the T-Logs after I have set up
> backup jobs for the data?|||This is a multi-part message in MIME format.
--=_NextPart_000_01DB_01C3AA9E.4191E160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
You will have to change the recovery model for the database to full or
bulk-logged.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Ray Ellers" <rellers@.flexiblesystems.com> wrote in message
news:40bf01c3aac7$6000b9e0$a601280a@.phx.gbl...
When setting up a backup of the database the option to
backup the transaction logs is grayed out. How do I set up
a seperate backup for the T-Logs after I have set up
backup jobs for the data?
--=_NextPart_000_01DB_01C3AA9E.4191E160
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
You will have to change the recovery =model for the database to full or bulk-logged.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Ray Ellers"
--=_NextPart_000_01DB_01C3AA9E.4191E160--
No comments:
Post a Comment