Use some sort of RAID as well.
-----Original Message-----
From: Suresh Patel (OfficeSpark) [mailto:mssqldba-ezmlmshield-x56361328.[Email address protected]
Sent: Friday, October 29, 2004 7:40 AM
To: LazyDBA Discussion
Subject: Re: Backup strategy
1. do a trans log backup every 15 minutes.
2. Copy these files away from production server to another every 7.5 mins
also
3. max dataloss you could have then is 7.5 mins.
4. I would do a full backup at 4.05 also
5. Have standby server ready if production goes down, make 2 copy the files
to standby.
SP
----- Original Message -----
From: "Đuro Dretvić "
<mssqldba-ezmlmshield-x83372018.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, October 29, 2004 12:14 PM
Subject: Backup strategy
> I need backup strategy for production database. (Best practices)
>
>
> Situation:
>
> Data loss is not acceptabe.
>
> Production time is from 8:00 AM to 4:00 PM. (M,T,W,T,F)
>
> Saturday and Sunday are not working days.
>
> I perform full backup every day at 22:00.
>
> I need to save all transactions during the day.
>
> Database is under heavy duty.
>
> How to perform that ?
>
> Transacion log backup or differential backup or .. and when.
>
> Sorry for the bad english.
>
> Regards Gj.
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page