I'm trying to copy a database from SQL Server 2008 R2 to another server, using the Copy Database Wizard in SQL Server Management Studio.
I get an error telling me to check the error log on the destination server. The log says:
Event Name: OnError Message: Access to the path '\\server\folder\db.mdf' is denied. StackTrace: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName , Boolean >overwrite) at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.CopyFile( String sourceFileName, String destinationFileName, Boolean overwriteOnExist)
It seems like my destination server can't access my network share on the source server.
The services "SQL Server" and "SQL Server Agent" are running under the account "network service" on both servers. This account has write permissions to my network share on the source server.
The database is too large to backup locally and then move to destination server through network share. There is not enough space on the local disk.
How can I resolve this issue?