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]
>-----Original Message----- >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? > >Any info would be great. >.
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