Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at. Pinal has authored 13 SQL Server database books and 45 Pluralsight courses. He holds a Masters of Science degree and numerous database certifications. Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. Users only need to make backups and restore when needed.ĭo you backup your master database? Please leave your comments here. The real purpose of the master database is for the SQL Server to maintain itself.
Users should not be required to modify or create anything in the master database. The master database should not contain any user-created objects. On further observation of his master database, I found that he has some system maintenance Stored Procedure created in the master database.
The master database is the most important database of all and the most recent version of the backup should be available in the case of disaster.The discussion that followed was very thought provoking and I would like to share the major points with you: He was a little astounded and asked me to tell him at what intervals he should backup the master database.
I was startled and couldn’t resist explaining to him that the master database contains all the logon accounts details, as well as all the system-level database configuration. When I questioned this, the DBA informed me that it was not necessary. While going through the plan, I noticed that there was no backup for the master database. During a recent consultancy project, I was asked to review a Database Backup plan.
0 kommentar(er)
