backup of transaction log

[alwinkotiya@gmail.com]

How to schedule backup of transaction log???

[Jack Vamvas]

Re: backup of transaction log

Use Jobs

----
Jack Vamvas
_______________ _______________ _____
Receive free SQL tips - www.ciquery.com/sqlserver.htm
_______________ _______________ _____


<alwinkotiya@gm ail.com> wrote in message
news:1150212250 .543197.268640@ g10g2000cwb.goo glegroups.com.. .[color=blue]
> How to schedule backup of transaction log???
>[/color]

[DickChristoph]

Re: backup of transaction log

Create a Database Maintenance Plan. In the Enterprise Manager goto
"<ServerNam e>", "Management " Right Click and say "New Maintenance Plan."

That is if you have SQL 7 or 2000 I don't know if it is different in 2005.

--
-Dick Christoph
<alwinkotiya@gm ail.com> wrote in message
news:1150212250 .543197.268640@ g10g2000cwb.goo glegroups.com.. .[color=blue]
> How to schedule backup of transaction log???
>[/color]