public:5294_operating_system_error_5
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
public:5294_operating_system_error_5 [2018/05/11 10:11] edward.chan |
public:5294_operating_system_error_5 [2021/12/16 06:11] (current) anna.olalia |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== ISSUE: Operating system error 5 (Access is denied) (MS SQL database backup) ===== | + | ===== [V7] ISSUE: Operating system error 5 (Access is denied) (MS SQL database backup) ===== |
| <html> | <html> | ||
| Line 10: | Line 10: | ||
| Reviewed: | Reviewed: | ||
| </b> | </b> | ||
| - | 26/01/2018 | + | 2018-01-26 |
| <br/> | <br/> | ||
| <br/> | <br/> | ||
| Line 22: | Line 22: | ||
| </html> | </html> | ||
| + | <html> | ||
| + | <FONT COLOR=red SIZE=+1> | ||
| + | <B>ATTENTION</B> | ||
| + | 1st January, 2022: v7 officially End-of-Life [<A HREF=https://wiki.ahsay.com/doku.php?id=public:announcement:ahsay_v7_eol>details</A>] | ||
| + | </FONT> | ||
| + | </html> | ||
| ===== Problem Description ===== | ===== Problem Description ===== | ||
| Line 119: | Line 125: | ||
| <br> | <br> | ||
| <br> | <br> | ||
| - | On the other hand, if the temporary directory is set to a network share, for SQL Server to access a remote disk, the SQL Server service account must have access to the network share. The availability of network drives and permissions depends on the context is which SQL Server service is running: | + | On the other hand, if the temporary directory is set to a network share, for SQL Server to access a remote disk, the SQL Server service account must have access to the network share. The availability of network drives and permissions depends on the context in which SQL Server service is running: |
| <br> | <br> | ||
| <ul> | <ul> | ||
| - | <li><font color=black>To back up to a network drive when SQL Server is running in a domain user account, the shared drive must be mapped as a network drive in the session where SQL Server is running. If you start Sqlservr.exe from command line, SQL Server sees any network drives you have mapped in your login session.</li></font><br> | + | <li><font color=black>To back up to a network drive when SQL Server is running in a domain user account, the shared drive must be mapped as a network drive in the session where SQL Server is running. If you start Sqlservr.exe from the command line, SQL Server sees any network drives you have mapped in your login session.</li></font><br> |
| <li><font color=black>When you run Sqlservr.exe as a service, SQL Server runs in a separate session that has no relation to your login session. The session in which a service runs can have its own mapped drives, although it usually does not.</li></font><br> | <li><font color=black>When you run Sqlservr.exe as a service, SQL Server runs in a separate session that has no relation to your login session. The session in which a service runs can have its own mapped drives, although it usually does not.</li></font><br> | ||
| Line 138: | Line 144: | ||
| Note: | Note: | ||
| <br> | <br> | ||
| - | There are some limitations to the VSS backup mode, refer to the Limitation and Backup Mode sections of the <a href="https://www.ahsay.com/download/download_document_obm-user-guide-sql.jsp">AhsayOBM Microsoft SQL Server Backup and Restore Guide</a> for details. | + | There are some limitations to the VSS backup mode, refer to the Limitation and Backup Mode sections of the <a href="http://download.ahsay.com/support/document/v7/guide_obm_user_mssql.pdf">AhsayOBM Microsoft SQL Server Backup and Restore Guide</a> for details. |
| </html> | </html> | ||
| ===== Keywords ===== | ===== Keywords ===== | ||
| sql, odbc, temp, vss, access, denied, mssql | sql, odbc, temp, vss, access, denied, mssql | ||
public/5294_operating_system_error_5.1526004671.txt.gz · Last modified: 2021/12/16 06:10 (external edit)