UNC for backup path
If I create a UNC (\\server\share) for the backup path to store backup of both site data and site database, what the permissions of the share need to be set?
Can this share be created on the site server ie
\\sccmserver\sharename ?
Note, local drive on site server option is not available as the SQL server is remote.
Thanks in advance,
November 30th, 2010 10:42pm
The computer account for the server holding the SMS Provider role needs full access as does the service account for your SQL Server instance. If the SQL Server instance is running as local system, then use the computer account for the system where the instance
is hosted.
These must of course have access at both share and NTFS levels; the best practice is to set everyone full at the share level and set explicit, granular permissions at the NTFS level though.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 11:28pm
Thanks, it's clear for my first question.
What about my second question: can this share actually be the local to the site server ie
\\sccmservername\sharename?
December 1st, 2010 4:33am
yes, it can be local to the site server.http://www.enhansoft.com/
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2010 6:14am
A quick revision. For the SQL backup portion, the computer account of the system hosting the SQL instance needs permissions and not the SQL Service Account. The SMS SQL Backup service on the SQL server is what is actually performing the backup of the DB
and thus it is what requires permissions to the UNC path.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
December 1st, 2010 3:03pm