Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2002-03-11 : 12:55:53
|
| HI,I have question about database recovery option.Right now for some databases we have option simple selected.I am doing every day full backup for two weeks.Do you think it's safe enough or should i change it to full option.This is developer's database. And then we send databses to client.What do you recommend for that.I read it in bol but still couldn't decide which one is the best. |
|
|
DGMelkin
Starting Member
24 Posts |
Posted - 2002-03-11 : 13:28:57
|
| It depends on how important recovery is. For a developer, it's not as important, so what you have now is probably okay. For a client, it's probably crucial. Depending on how the client is using the database, you will either want to keep the simple recovery option and add differential backups or (what I would typically use) set the recovery option back to FULL and run transaction backups (and possible differential as well) throughout the day. It just depends on how critical the data is to your client.--D |
 |
|
|
|
|
|
Database recovery option