Sql-server – Are database options backed up in a full backup

sql serversql-server-2016

Are database options backed up in a full backup?

For instance, I have a database which has AUTO_UPDATE_STATISTICS disabled (0) (AFAIK, default is 1).
When I restore a full backup of that database, does this option stay disabled(0)?

Can you point me to any reference that mentions that?

Best Answer

db options gets restored except the ones like service broker, cdc, as mentioned here which you have to explicitly tell when restoring the db.

I tested the autoupdate stats - setting it to false, backing up db and restoring it as different name.

For new db, you can just set the model db settings and it will get inherited.