Make sure to understand it correctly, as I have small question at the end of the timeline.ĩ:00 AM – DBA takes backup of the master database.ġ0:00 AM – DBA creates new Database named AfterMaster.ġ1:00 AM – DBA restores the master database backup taken at 9:00 AM.ġ2:00 PM – I have following two questions for the DBA : We will take example of SQL Server DBA and follow his timeline. ![]() Let us understand the important of the master database using an example. If master database is damaged, it will be difficult to use any other database in SQL Server and that makes it most important database of the SQL Server. Information about all the login account, system configurations and information required to access all the other database are stored in master database. Master database contains all the system level information of server. ![]() Just a day before I wrote article about SQL SERVER – Restore Master Database – An Easy Solution, right following it, I received email from user requesting reason for importance of backing up master database. The most interesting thing about writing blog at is follow up question.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |