"Charles Wang[MSFT]" wrote:

> Hi,
> Thanks for your post!
>
> My understanding of your issue is:
> You wanted the best strategy for SQL Server database backup.
> If I have misunderstood, please let me know.
>
> Generally, different situations require different backup strategies.
> It's difficult to say which one is the best.
> You might back up your database frequently if your system is in an online
> transaction processing (OLTP) environment.
> You might back up your database less frequently if your system has little
> activity or is used primarily for decision support.
> You should schedule backups when SQL Server is not in the process of
> being heavily updated.
> After you determine your backup strategy, you can automate the process by
> using the Database Maintenance Plan Wizard.
>
> Also, you may refer to:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> _bkprst_63eh.asp
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest
> .mspx
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> _bkprst_7drn.asp
>
> If you have any other concerns, please feel free to let me know. It's my
> pleasure to be of assistance.
>
> +++++++++++++++++++++++++++
> Charles Wang
> Microsoft Online Partner Support
> +++++++++++++++++++++++++++
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
>
> This and other support options are available here:
>
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others:
>  https://partner.microsoft.com/US/technicalsupport/supportoverview/
>
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>