Transfer Database Offline - network share file not found?
Hello, I am trying to transfer a database offline between two servers. I have specified SourceDatabasefiles and DestinationDatabaseFiles. I created two folders and made them shared on both source(`\\EAPRDSQL41\Source_Share` is the shared folder on the source) and destination. I specified the "Network file Share" on both Source and Destination files. But when I run the package, I get the error: [Transfer Database Task] Error: The following exception occurred during an offline database transfer: System.IO.FileNotFoundException: Could not find file '\\EAPRDSQL41\Source_Share\SourceDatabase.mdf'. File name: '\\EAPRDSQL41\Source_Share\SourceDatabase.mdf' Why is the package looking for the mdf file located on the Network File share? Isn't the task supposed to create that file first? Thank you!
Looks like you specified the share starting with a single \ instead of a double \. A network share needs to start with \\\\ and not a single \\ . After that, verify permissions exist such that users and service accounts can reach that share from both servers.
The task does not create the source `.mdf` file, it copies the existing one to the destination network share. Your source share needs to be the full network path to the `.mdf` file of the database you want to transfer. "When you use offline mode, the database is detached, the database files are copied or moved, and the database is attached at the destination after the transfer finishes successfully. If the database is copied, it is automatically reattached at the source if the copy is successful" - [