Thursday, March 29, 2012

Backup Strategy

My client has about 2TB data, are there any recommended
backup strategy? Does SAN / NAS helps?Hi,
The best method for 2 TB database will be,
1. Perform a Diffrential Backup daily once
2. Perform a Transaction Log backup every 30 Minutes (U can change based on
daily growth)
Since the volume is very huge ideal way to keep the backup devices will be
either SAN or NAS.
Thanks
Hari
MCDBA
"Peter Wong" <anonymous@.discussions.microsoft.com> wrote in message
news:0a8d01c3d9a9$d97e0140$a101280a@.phx.gbl...
quote:

> My client has about 2TB data, are there any recommended
> backup strategy? Does SAN / NAS helps?
|||You might also take a look at filegroup backups, which are intended for very
large databases. These are doc'd in books on line... You might have to move
data around into new filegroups to implement this, but it would allow you to
back up part of the database each night...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Peter Wong" <anonymous@.discussions.microsoft.com> wrote in message
news:0a8d01c3d9a9$d97e0140$a101280a@.phx.gbl...
quote:

> My client has about 2TB data, are there any recommended
> backup strategy? Does SAN / NAS helps?
sql

No comments:

Post a Comment