Backing up and ever growing database

Dear Sirs,
I have an sql 2000 ever growing databse, 24 hours a day 7 days a week,
what is the best to back it up. All the data is critical to be
preserved.
Any method would be apreciated.
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Elie
.htm#Step1" target="_blank">http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting
best practices
"elie chucrallah" <eliechucrallah@.hotmail.com> wrote in message
news:eYA8V5qUEHA.808@.tk2msftngp13.phx.gbl...
>
> Dear Sirs,
> I have an sql 2000 ever growing databse, 24 hours a day 7 days a week,
> what is the best to back it up. All the data is critical to be
> preserved.
> Any method would be apreciated.
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi,
I suggest you to do below backup strategy:-
1. Sunday - Full database Backup
2. Every day night - Differential backup
3. Every 30 minutes or 1 hour Transaction log backup.
have a look into the details of above strategies:-
http://techrepublic.com.com/5100-6268-1043671-3.html
Thanks
Hari
MCDBA
"elie chucrallah" <eliechucrallah@.hotmail.com> wrote in message
news:eYA8V5qUEHA.808@.tk2msftngp13.phx.gbl...
>
> Dear Sirs,
> I have an sql 2000 ever growing databse, 24 hours a day 7 days a week,
> what is the best to back it up. All the data is critical to be
> preserved.
> Any method would be apreciated.
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hari
Each Diff backup will be grown so on Saturday you will have a pretty big
file and look,if you want to restore database you will need to restore FULL
backup and then a bigger (last) DIFF backup which will consume more time
and resourse.
In my opinion he can do it every night FULL backup of the database and then
every 30 min or an hour LOG file.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23SfnEVrUEHA.1020@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I suggest you to do below backup strategy:-
> 1. Sunday - Full database Backup
> 2. Every day night - Differential backup
> 3. Every 30 minutes or 1 hour Transaction log backup.
> have a look into the details of above strategies:-
> http://techrepublic.com.com/5100-6268-1043671-3.html
>
> --
> Thanks
> Hari
> MCDBA
> "elie chucrallah" <eliechucrallah@.hotmail.com> wrote in message
> news:eYA8V5qUEHA.808@.tk2msftngp13.phx.gbl...
>|||thxs for those suggestions
In fact the data is so important that we are doing a transaction log
back up every 5 minutes, i was thinking maybe another backup server with
data synchronized continuesly like replication or something, or maybe
mdf files synchronization.
any suggestion from someone with such experience would be much
apreciated
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!|||If you are worried about losing data in that 5 minute window, the easiest
solution would be to use RAID 1,5, or 10 for your data files and log files.
For heavy duty real-time synchronisation, you would be looking at
implementing remote mirroring on a SAN.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"elie chucrallah" <eliechucrallah@.hotmail.com> wrote in message
news:e7N%23I9rUEHA.4088@.TK2MSFTNGP09.phx.gbl...
>
> thxs for those suggestions
> In fact the data is so important that we are doing a transaction log
> back up every 5 minutes, i was thinking maybe another backup server with
> data synchronized continuesly like replication or something, or maybe
> mdf files synchronization.
> any suggestion from someone with such experience would be much
> apreciated
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Elie
You can set up LOG_SHIPPING.
http://www.sql-server-performance.c...og_shipping.asp
"elie chucrallah" <eliechucrallah@.hotmail.com> wrote in message
news:e7N%23I9rUEHA.4088@.TK2MSFTNGP09.phx.gbl...
>
> thxs for those suggestions
> In fact the data is so important that we are doing a transaction log
> back up every 5 minutes, i was thinking maybe another backup server with
> data synchronized continuesly like replication or something, or maybe
> mdf files synchronization.
> any suggestion from someone with such experience would be much
> apreciated
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi Uri,
I agree with you 90%, rest 10% I disagree because if the database size grows
above 50Gb, it is always
advised to do a differential during week days. This will save your backup
time as well as reduce the IO used for backup operations.
Do you agree with me or
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ukTnZprUEHA.1012@.TK2MSFTNGP09.phx.gbl...
> Hari
> Each Diff backup will be grown so on Saturday you will have a pretty big
> file and look,if you want to restore database you will need to restore
FULL
> backup and then a bigger (last) DIFF backup which will consume more time
> and resourse.
> In my opinion he can do it every night FULL backup of the database and
then
> every 30 min or an hour LOG file.
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23SfnEVrUEHA.1020@.TK2MSFTNGP11.phx.gbl...
>|||Well
What is about restoring ?
I'd use DIFF backup if amount of time spent in recovering the database by
applying all the transaction logs is not acceptable.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:OpHxsgsUEHA.3944@.TK2MSFTNGP12.phx.gbl...
> Hi Uri,
> I agree with you 90%, rest 10% I disagree because if the database size
grows
> above 50Gb, it is always
> advised to do a differential during week days. This will save your backup
> time as well as reduce the IO used for backup operations.
> Do you agree with me or
>
> --
> Thanks
> Hari
> MCDBA
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ukTnZprUEHA.1012@.TK2MSFTNGP09.phx.gbl...
> FULL
time[vbcol=seagreen]
> then
week,[vbcol=seagreen]
>|||Hi,
OK I Agree, Both areas got it own demerits. But still if you have a huge
database (1 TB) the full database
backup is not a feasible solution because it will take a long time even in a
SAN .
Restore?
In case of Restore, I will restore the Differential backup taken last night
and start applying the Transaction log one by one till last file.
Please explain me if you have a better approach.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urcN7nsUEHA.4064@.TK2MSFTNGP11.phx.gbl...
> Well
> What is about restoring ?
> I'd use DIFF backup if amount of time spent in recovering the database by
> applying all the transaction logs is not acceptable.
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:OpHxsgsUEHA.3944@.TK2MSFTNGP12.phx.gbl...
> grows
backup[vbcol=seagreen]
big[vbcol=seagreen]
> time
> week,
>sql