Can i choose Partial Database for MSSQL Master Database
Expected Error -> ODBC Error Number:42000 [You can only perform a full backup of the master database]
The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings
It is by design that SQL Server is designed to allow only FULL backup of the master database, But why? The reason is that to apply partial, or differential backups to a database, the database has to be in No recovery (Recovering) state. However, SQL Server does not allow the master database to be restored without recovery. For this reason, the master database has to be in Recovered state always
Suggested ( https://github.com/MicrosoftDocs/sql-docs/issues/5171 ) Microsoft to Highlight this Tendency in their Documentation and the same was approved and the amend can be seen in the Database restriction section of docs.microsoft.com
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center