Master Database Can it be backedup as Partial database / Differential

[MuthuramanD]

This topic has answer in a old MS community thread ( https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4c9308b9-5329-458f-8a69-10eec9ef6824/master-database-differential-backup?forum=sqldisasterrecovery)

However there is no mention on the SQL Quide , can you confirm if this option is allowed else can we have a note added in the guide in this field

[WilliamAntonRohm]

@MuthuramanD -- thank you for your feedback. Please provide the URL to the docs.microsoft.com article you'd like us to update. Meanwhile, consider these resources:

• DBA Stack Exchange
• Stack Overflow

[MuthuramanD]

@WilliamAntonRohm

Thanks for considering the feedback.

Basically it Applies for all the MSSQL Database Documentation -> here is the below link

https://docs.microsoft.com/en-in/sql/relational-databases/databases/master-database?view=sql-server-ver15

[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

Hence it is best to add a caption stating that Under " Master DB can only be backed up as FULL Backup

A place to add this information

https://docs.microsoft.com/en-in/sql/relational-databases/databases/master-database?view=sql-server-ver15

Under Restriction -> the above verbatim can be added.]

Also without realizing I created a duplicate entry of the same query, APologies, please Consolidate them

#5207

[WilliamAntonRohm]

@MuthuramanD -- Muthuraman, thank you for your thorough feedback.

@stevestein -- Steve, please look into this issue (was #5207).

[MuthuramanD]

Thanks much will keep awaiting for the amends in the document

[MuthuramanD]

@stevestein @WilliamAntonRohm -> Any ETA I can hold upon as one of a customer had to respond to the client about this behavior for an implementation query Many Thanks

[stevestein]

@MuthuramanD - thanks for the feedback. I added this item to the list:

Thanks!

[MuthuramanD]

thanks much (Y) @stevestein

[stevestein]

#please-close