| |
|
Best practice while doing SQL Maintenance plan?
Question Posted on 14 Feb 2022
Home >> DataBase >> sql questions >> Best practice while doing SQL Maintenance plan? |
Best practice while doing SQL Maintenance plan?
Below are the 10 most usefull point which need to take care beofore doing any maintenance for SQL and this may cover backup and restore process in case of any crash.
(1)Full Daily Backup(Daily):-This one of the most important aspects of maintenance which contains full backup. But you must check the storage and number of days to kept the backup must be define. Some company will take care 30 days backup and some or doing only for 3 days. It is depend on storage avaialble and type of your business.
(2)Differential Backup(Hourly):-There are certain business which required this type of backup which include some particular tables and procs.
(3)Transaction Log Backups(15 Min):-You can take this of full database or some parts let suppose for some specific tables.
(4)Check DB Integrity:-I will advice you to avaiod this in peak hours of your business as this process will scan all of your database which may chop your bandwidth. SO try to sechdule this in offline hours.
(5)Reorganize Indexing:-This need to be done on demand.I advice not to do this on daily basis if not required. Move all index and statistics operations on a single weekly task.
(6)Update statistics:- This should be also done on demand not on daily basis my answer is same as previous.
(7)Shrink Database(Weekly):- Please avoid such thinks if you can.
(8)Rebuild Index:-Same as Reorganize Indexing
(9)Maintenance Cleanup(Daily):-My answer is yes for this.
(10)Restore verification:-Always try and test restore process as this may helps you in case of any issue persist or failure of system. | |
|
|
|
|