Backup of transaction log

Alwin,
Create a job, use statement "backup log", and schedule the job.
AMB
"Alwin" wrote:

> How to schedule backup of transaction log?
>Thanks AMB for your quick reply ,
But I am new to sql server can you tell me stepswise solution.
Alejandro Mesa wrote:
[vbcol=seagreen]
> Alwin,
> Create a job, use statement "backup log", and schedule the job.
>
> AMB
> "Alwin" wrote:
>|||How to schedule backup of transaction log?|||Alwin,
Create a job, use statement "backup log", and schedule the job.
AMB
"Alwin" wrote:

> How to schedule backup of transaction log?
>|||Thanks AMB for your quick reply ,
But I am new to sql server can you tell me stepswise solution.
Alejandro Mesa wrote:
[vbcol=seagreen]
> Alwin,
> Create a job, use statement "backup log", and schedule the job.
>
> AMB
> "Alwin" wrote:
>|||Alwin wrote:
> Thanks AMB for your quick reply ,
> But I am new to sql server can you tell me stepswise solution.
>
> Alejandro Mesa wrote:
>
>
IF you're not familiar with SQL programming, the easiest might be to
create a maintenance plan to do the job. You can read up on maintenance
plans in Books On Line.
Regards
Steen Schlter Persson
DBA|||Alwin wrote:
> Thanks AMB for your quick reply ,
> But I am new to sql server can you tell me stepswise solution.
>
> Alejandro Mesa wrote:
>
>
IF you're not familiar with SQL programming, the easiest might be to
create a maintenance plan to do the job. You can read up on maintenance
plans in Books On Line.
Regards
Steen Schlter Persson
DBA