backup plan

Hello,
I would to do a backup plan and I would like to know if someone can
help me with some advice?
What I have done until now is to do the transaction log (10:50 PM)
before the data backup (11:00) PM.
Do you think there is problem on doing that?
InaIf this plan includes new databases and you are using SQL Server 2000, the
transaction log backup could fail for these new databases.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ina" wrote:

> Hello,
> I would to do a backup plan and I would like to know if someone can
> help me with some advice?
> What I have done until now is to do the transaction log (10:50 PM)
> before the data backup (11:00) PM.
> Do you think there is problem on doing that?
> Ina
>|||ina
I can tell you what I'm doing in my company. I have a FULL database backup
at 2PM and LOG backup every 30 minutes from 4PM to 1:30AM
It is matter of policy at your company how much data can you lose?
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1146723393.832760.294060@.e56g2000cwe.googlegroups.com...
> Hello,
> I would to do a backup plan and I would like to know if someone can
> help me with some advice?
> What I have done until now is to do the transaction log (10:50 PM)
> before the data backup (11:00) PM.
> Do you think there is problem on doing that?
> Ina
>|||This plan includes new databases. I am pretty newbie on sql server. Do
you think it is better to postpone the transaction log such as 10 min
earier?
Ina|||Thank you Ben,
yes. it includes new database. I am pretty newbien in SQL Server 2000.
Do you think Do I need to postpone my T log to i.e 10 min earlier
Ina|||Thanks,
Let me understand Do I need the transaction log be backed up often. and
even for a small company? Could you explain me why? and could people
work even if the Transaction log backup is running?
Ina|||ina
It is up to you how often to backup log file or to backup log file at all ,
have you considered to set the database to SIMPLE recovery mode and
performing FULL backup once a day? Some people do the backup log file very
10 minutes because they cannot afford to lose data even in this period
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1146725751.358542.287290@.j33g2000cwa.googlegroups.com...
> Thanks,
> Let me understand Do I need the transaction log be backed up often. and
> even for a small company? Could you explain me why? and could people
> work even if the Transaction log backup is running?
> Ina
>|||My database is set to FULL and my full backup once a day at 11:00 AM
and the backup log from 4 PM until 10:30 Pm every hour is it ok?
Is it better to set to SIMPLE if I set it I cannot perform transaction
log backup
Ina|||ina

> Is it better to set to SIMPLE if I set it I cannot perform transaction
> log backup
How important is to BACKUP LOG file for the company
Please read this article
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting best practices
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1146726890.661053.129620@.i40g2000cwc.googlegroups.com...
> My database is set to FULL and my full backup once a day at 11:00 AM
> and the backup log from 4 PM until 10:30 Pm every hour is it ok?
> Is it better to set to SIMPLE if I set it I cannot perform transaction
> log backup
> Ina
>|||it is 11:00 Pm sorry
Ina