Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to simulate disaster recovery
Message
From
29/07/1999 17:45:04
 
 
To
29/07/1999 11:33:10
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Miscellaneous
Thread ID:
00247369
Message ID:
00247969
Views:
22
Ross,

How offen you backup depends on three things:

1) The volume of data
2) The volatility of the data
3) How much data your willing to lose

With such a small amount of data, I don't see any reason that you can't schedule a full database backup nightly. For the TLog backups, that's really a matter of #2 and #3.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform