Using 12.3
Is there a way to restore a DB to a CIFS share? I have a MS SQL VM that points to a CIFS share location on our NetApp SAN. When I try and do a restore I cannot specify the Database files target location to anything other that a drive the server sees as local, meaning not a cifs share, or a network mapped drive.
+23Hi, you say restore but do you mean to export the database?
I haven’t got my lab powered on to try this but I’d suspect when you mention mapped drives it’s likely to do with the user account that the Veeam service is running under not having a mapped drive.
No I meant restore. Just like I can redirect a restore of a DB from a backup on SQL1 to a different SQL server, I’m trying to restore to a SQL server that has a CIFS share as its default data and log storage. I did not try an export.
Not from the Explorers. The explorer and the datamover agent have no way to interact appropriately to the SMB share (shares are not shared between user sessions). Export the DB and restore it or stage it on a local disk first on the SQL server, then move it on the SQL server itself.
SMB is extremely tricky especially with remote permissions -- it’s regrettably not as simple as “if the computer can access the share”, there are a ton of SMB security features that make this pretty difficult.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
