Tuesday, 13 August 2013

No file access permissions after restore database

No file access permissions after restore database

I have a strange phenomon. When I restore a SQL-Server 2012 database to a
folder on my D-Drive, it gets restored just fine. I can access the
database and basically it works fine. But when I check the file access
permissions of the mdf and ldf files, there are no permissions listed, and
there is no owner listed. The MSSQLSERVER service account has full access
to the complete D-drive, so I would expect that the newly created mdf and
ldf would inherit their permissions from the folder (which has all the
permissions, including full access for the MSSQLSERVER account).
The user that is restoring the database, is a member of sysadmin server
role and is a administrator on the Windows server.
Why do the database files have no file access permissions listed?? I do
not get access denied or anything. Hope someone can help me with this.
best regards, Rob

No comments:

Post a Comment