Wednesday, March 7, 2012

backup of transaction log

How to schedule backup of transaction log?Use Jobs

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

<alwinkotiya@.gmail.com> wrote in message
news:1150212250.543197.268640@.g10g2000cwb.googlegr oups.com...
> How to schedule backup of transaction log?|||Create a Database Maintenance Plan. In the Enterprise Manager goto
"<ServerName>", "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@.gmail.com> wrote in message
news:1150212250.543197.268640@.g10g2000cwb.googlegr oups.com...
> How to schedule backup of transaction log?

No comments:

Post a Comment