Creating a Disaster Recovery Plan for your database (SQL)
Creating a Disaster Recovery Plan for your database (SQL) Idera recently had a fantastic webinar that went over the creation of a disaster recovery plan concerning your databases. This should be a high critical piece of work usually done by DBAs within a company. Let's go over a simple set of plans that depending on the type of company you are dealing with, can be done either large or small. Backups. All backups should be done with incremental or full backups of your database. There should be a protected network folder that contains the incremental in one and the full backups (usually done once a week) in a separate folder. An incremental is a backup that contains only a snapshot of transactions that are done during a day while…