Skip to main content

Adding security on a mssql file, when moving backups or data files around

Every now and then you need to move a MSSQL database file around.

However, how to do you put the MSSQL security attributes back on the file.

Turns out it is real easy, all you need to do is put "NT Service" in front of  the database name

ie:
NT Service\MSSQL$InstanceName

For me, that was
NT Service\MSSQL$PBSQL


Comments