When mirroring a backup file, the following errors display:
Error: "Could not read the drive details for '\\<servername>\d$\': Ensure target exists and available."
and
"Could not read the drive details for '\\<servername>\d$\': Ensure target exists and available."
( where <servername> is our server) i can browse to the drive and set a destination.
and this error message:
60405 : LiteSpeed for SQL Server could not open backup file: (\<servername>\d$\mssqldata\backup\<dbname>.bak). The previous system message is the reason for the failure.
Mapping the network drive fails with same resulting error. However, backing up to a local mirror on the machine to another drive on the local machine is successful.
WORKAROUND:
The SQL Server service account must have access to that remote share. Browsing uses the login account. I would not recommend mapping, as that is user-based and mapping the drive from Windows won't help the SQL Server service account gain access. You can log into the server as the SQL service account and verify it has access to the share or you can simply grant the account read-write access to the share.
It's the account you are using for the SQL Server Service. You can check which account is used from the SQL Server Configuration Manager or from Services.
