Sql Management Plans - Backup
To backup database there are several options. It depends on how much data loss is acceptable. Based on the the back up plan can be designed. Also it is important to know how critical the data is and what level of backup is required. Again with high critical conditions, high availability high cost will be in place.
Let us consider a scenario where we can afford to loose data maximum of only one hour.
In this backup design we can have the following.
1. Backup full database every day using sql management plan.
2. Use the maintenance clean up task in sql management plan to maintain 5 days of full back up file and delte the rest.
3. Rebuild the index if requiired.
4. Back up log file
5. Shrink the log file to maintain the log file size in control.
Example show below in the figure
By clicking each task the sql script can also be generated
thanks. you may also try the recovery mdf file program, it quickly parses corrupted files of specified format and retrieves the source data from affected documents when possible. It may become a good addition to other ways of keeping your data safe
ReplyDelete