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
>|||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|||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
>|||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|||it is 11:00 Pm sorry
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_server_administration_best_practices.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 important; I am asking myself if the log file is updated
automatically when I do the DATABASE - Complete option.; so I do not
need to do a Transaction log backup up
Ina|||ina wrote:
> 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
>
Hi Ina
Do you run your business on "odd" hours since you are doing the database
at 11 AM? It's not a problem as such, but normally you'd run your full
database backup at a time where the load on the system is low (e.g. in
the night) and then you'll run LOG backups every x hours/minutes during
normal production.
I think you should read up on BACKUP and RESTORE in Books On Line. That
will give you a better understanding on how BAckup and Restore works.
Regards
Steen|||ina wrote:
> It is important; I am asking myself if the log file is updated
> automatically when I do the DATABASE - Complete option.; so I do not
> need to do a Transaction log backup up
> Ina
>
Hi Ina
I'm not sure what you mean about the log being updated, but nevertheless
I think the answer is no..:-). A database backup doesn't do anything
with the log file. The database backup only takes as much info from the
log as it needs to be able to restore a working database with the data
contained in the Database file at the time the backup is taken.
If your database is running in FULL recovery mode, you'll need to run a
BACKUP LOG in order to get your transaction log truncated - a BACKUP
DATABASE will not do this.
Regards
Steen|||Thank you, I am pretty newbie on that... but I am going on
Ina :)|||"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?
>
Yes. You can fully access SQL Server while doing either transaction log or
full backups.
Though disk I/O will be a bit slower.
To answer your basic question, yes, what you do now "works" but overall
isn't overly useful.
How often to do transaction log backups.. ask yourself, in your case if the
server crashes at 10:49 PM, is it ok if you only have the full backup from
the previous night? Can you lose all that data?
If so, then I'd just go into simple recovery mode and do full backups.
If not, then do transaction log backups more often. Perhaps every 4 hours.
Perhaps every 10 minutes. Again, it depends mostly on your business needs.
> Ina
>