Back Up Strategy

Would like to take your valuable views on ,What’s the best strategy for
Database back up and files back up:-
I have few options:-
? Using Database Maintenance plan
? Using State Store
? On SQL Server, using Differential on daily & Complete back on wend..
? Other options :-
Thanks...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/d...-us/adminsql/ad
_bkprst_63eh.asp
http://www.microsoft.com/technet/pr...n/sqlbackuprest
.mspx
http://msdn.microsoft.com/library/d...-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 w 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/te...erview/40010469
Others:
https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.