Backup & recovery strategy - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Backup & recovery strategy

Author

Topic

roshana
Starting Member

31 Posts

Posted - 2010-05-10 : 02:30:36

Hi All,
I have n number of client databases which is using SQL server compact edition 3.5 SP1 (CE).And the central server SQL server 2008 Enterprise edition. When ever network connection enabled i will transfer data from the CE to server, and delete the data from the CE database using MSMQ. Can anybody suggest what backup and recovery strategy I should use in this situation? So that the data lose is very less in the server.

Thanks,
Roshana

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-10 : 12:46:10

I don't see any reason why your backup strategy would be different than other systems.

Here is our backup plan:
1. Nightly full backup
2. Tlog backups every 15 minutes

On some systems, we also have a differential kick off 12 hours after the full backup.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

roshana
Starting Member

31 Posts

Posted - 2010-05-11 : 20:14:59

Thanks Tara Kizer

Thanks for your valuable suggestion

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-12 : 12:36:02

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources