all groups > sql server replication > november 2003 >
You're in the

sql server replication

group:

Very Large SQL Databases


Very Large SQL Databases Jeremy
11/6/2003 7:25:35 AM
sql server replication:
Currently my work database is 80GB
I am in the process of developing a new backup and
recovery plan for future database growth of up to 500GB.
Has anyone worked with SQL databases of this size?

Very Large SQL Databases lt
11/6/2003 8:56:30 AM
Check out Bakbone Software Inc. it have a very fast backup
and recovery product.
[quoted text, click to view]
Very Large SQL Databases Allan Hirt
11/9/2003 5:04:59 PM
First, what are your requirements? DBs, large and small,
have both similar and different characteristics. What are
your SLAs, and what are your retention times?

YOu should use a combination of full, differential, and
transaction log backups to get you closer to that point of
failure. How many files you will need in your restore
depends on what strategy you take.

For example, if you do a full weekly, differentials every
day, and then transaction logs every n minutes or hours,
you would need the full, the latest differential, and the
right transaction logs.

The book SQL Server 2000 High Availability by MS Press has
2 chapters dedicated to backup and restore that may help
AddThis Social Bookmark Button