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:
> Alwin,
> Create a job, use statement "backup log", and schedule the job.
>
> AMB
> "Alwin" wrote:
> > How to schedule backup of transaction log?
> >
> >|||Alwin wrote:
> Thanks AMB for your quick reply ,
> But I am new to sql server can you tell me stepswise solution.
>
> Alejandro Mesa wrote:
>> Alwin,
>> Create a job, use statement "backup log", and schedule the job.
>>
>> AMB
>> "Alwin" wrote:
>> How to schedule backup of transaction log?
>>
>
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 Schlüter Persson
DBA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment