![]() ![]() For more information, see Rebuild System Databases. If severe damage to master prevents you from starting SQL Server, you must rebuild master. ![]() For more information, see Restore the master Database (Transact-SQL). If you can start the server instance, you should be able to restore master from a full database backup. Restore master from a current database backup. If master becomes unusable, you can return the database to a usable state in either of the following ways: If you do, master must be backed up more frequently.ĭo not set the TRUSTWORTHY option to ON for the master database. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings. Changing server or database configuration valuesĭo not create user objects in master. The master database records all the system-level information for a SQL Server system.Creating, modifying, or dropping any database.When you work with the master database, consider the following recommendations:Īlways have a current backup of the master database available.īack up the master database as soon as possible after the following operations: Setting the database or primary filegroup to READ_ONLY. SQL Server includes a number of encryption features and capabilities that you can use to secure your systems.It is common to see DBAs add objects like those to support database maintenance to the master database. Other objects should be placed in a user database. ![]() It would be ok to add a stored procedure like spwhoisactive to the master database. Renaming the database or primary filegroup. SQL Server will allow objects to be added to the master database, but that should rarely happen. ![]()
0 Comments
Leave a Reply. |