question

Troy_2012 avatar image
Troy_2012 asked

Unable to find the Backup Files from SSMS

Dear All ... I hope someone can help me with this issue I have a server named [Server1] member in domain Controller. I have two SQL instances on [Server1] . - [Server1 (DC\Kim)]default instance run under [NT Service\\MSSQLSERVER] account - [Server1\\SSSRSS]name instance run under domain user account [DC\sqlsrv] and this account is member on [Administrations Group] on [Server1] . I put the backup file on [c:\Backup] , when I tried to restore the DB , I couldn't find the backup file through the GUI from the two instance. until I added the [Server1\Users] group in the security folder [Backup] the backup file appear. And the Use that I login the [Server1] is member of Enterprise Admins ,Domain Admins and Schema Admins group. Also I checked the [Users Group] on [Server1] the members of this Group are : [DC\\Domain Users] ![alt text][1] So what is wrong with my security privilege. [1]: /storage/temp/3175-1.jpg
sqlserver2012windows-server-2012
1.jpg (8.1 KiB)
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
0 Likes 0 ·

2 Answers

·
Grant Fritchey avatar image
Grant Fritchey answered
It has to do with which service that SQL Server itself is running under and if that service has access to the drive in question.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Troy_2012 avatar image Troy_2012 commented ·
but the service have full access , correct me if I wrong, it's not enough that the [DC\sqlsrv]is member on [Administrations Group] on [Server1], and what about the virtual accounts that can access the network in a domain environment.
0 Likes 0 ·
Troy_2012 avatar image
Troy_2012 answered
Today I restarted all the servers , Now any SQL services run under Domain users that are member of Administrator can see the backup files from GUI , but the service run under virtual account [NT Services] or Network Services from GUI I can't see the backup file until I add the [Users Group] in the folder security...Why is that ?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

perrywhittle avatar image perrywhittle commented ·
any service running under the virtual account [NT SERVICE} will act as the computername on the network or for authentication to a folder\file. Grant the computers account DC\Server1$ access to the folder and the service will be able to access the files Regards Perry
2 Likes 2 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.