Closed gbargsley closed 1 year ago
So you have a vanilla installation of SQL Server 2019 and found those files there?
Yes on multiple boxes. I cannot find it in any MS docs, but it seems related to a feature.
What method did you use to install it?
Engine only with all the defaults.
I just installed SQL Server 2019 enterprise edition and encountered the same thing. I have 4 extra model db files in the default directory.
model_msdbdata.mdf model_msdblog.ldf model_replicatedmaster.ldf model_replicatedmaster.mdf
I can confirm this is an issue with 2019 installs. Have encountered it with Developer Edition and Standard Edition.
are yall running Find-DbaDbOrphanFile
?
Those files are listed here with a now retired feature: https://docs.microsoft.com/en-us/sql/big-data-cluster/deployment-high-availability?view=sql-server-ver16.
Shame I was looking forward to maybe having an MSDB and aspects of the master database that could be more AG aware.
Fixed with https://github.com/dataplat/dbatools/pull/6395.
Environmental information
Report
With the SQL 2019 installation the following four files are now being dropped in the DATA folder by default.
model_msdbdata.mdf model_msdblog.ldf model_replicatedmaster.ldf model_replicatedmaster.mdf
The current version of the function identifies these as orphaned because they are not hosted by SQL Server, but I believe they are there for AG replication of system files or for some other SQL related feature. I would not recommend displaying these as orphaned as deleting them might break the SQL 2019 instance.
#### Host used - [ ] powershell.exe - [ ] ISE - [ ] VS Code - [ ] Other (please specify) If anything other than powershell.exe was used, please confirm that you can duplicate the issue with powershell.exe - [ ] Still buggy in powershell.exe #### Errors ReceivedSteps to Reproduce
Expected Behavior
Actual Behavior