Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

What's the good backup plan for Dynamics CRM

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

What's the good backup plan for Dynamics CRM

Postby blin » Wed Feb 22, 2012 11:09 am

This is a problem I often meet. As I'm not a DBA, I do not have the necessary knowledge to be able to create a good backup plan for MS CRM.

Let's assume the following:
- My Org DB is about 10 GB
- I need a full backup every WE and a differential backup every night. Well, I suppose this is a good choice when the customer accepts to loose a max of 1 day of work.

Now, I don't know exactly how to build the backup plan in Management Studio, being sure:
- To backup the good data and being sure to be capable of restoring my data
- To avoid uncontrolable log file growth leading to a full disk
- To retain only 2 weeks of backup

If someone could drive me on this subject, it would be nice!
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 2367
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Re: What's the good backup plan for Dynamics CRM

Postby blin » Wed Feb 22, 2012 11:09 am

1-I checked our scripts and we have an specific step to delete files older than 30 days. I think the expire option does not delete the files, but simply marks the 'backup' in the file as expired.
2-This depends on the backup type. I'm not sure what transaction log backup types out of the box sql server supports. There are usually two types:
a. copy - this backs up the log files and does not truncate/delete them. So if there is a restore all you need is the full sql backup & the last log backup.
b. standard - this backs up the log files and truncates them. If there is a restore you need to restore the full sql backup & all the log backups since the last full sql backup.
3-Yep - weekend works ok. I wrote wed as a recent client I worked with performed full backups on wed :-)

Also - take a look at a backup package such as Symanted/Veritas BackupExec. We use it for sql server backups and it does a nice job facilitating the backups and disaster recovery for windows and sql server.
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 2367
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 2 guests