Hi Team,
I am trying to restore data base from my local folder to remote SQL Server, but ending up with below error.
Also i am aware that , we can’t restore database to remote server using .bak file using “SQLBackupAndFTP” tool but we can achieve through .sql file. Please correct me if i am wrong.
Please help me on steps to restore db using .sql file in remote server using “SQLBackupAndFTP” .
Log Details :
9/29/2019 1:28 PM Connecting to Remote SQL Server: 2017 RTM Express Edition (64-bit). XXX.XXX.XXX.XX
9/29/2019 1:28 PM Connecting to Folder destination “D:\Auto DB BackUP”
9/29/2019 1:28 PM Searching files in “Auto DB BackUP” folder by “XXXXX*” mask
9/29/2019 1:28 PM Found “3” files.
9/29/2019 1:28 PM Restoring “XXXXX” database on “Saturday, September 28, 2019 10:07 PM” from backup of “XXXXX” database
9/29/2019 1:28 PM Downloading file “XXXXX201909282207.zip” to “C:\WINDOWS\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup\f90f2950-1edd-4e89-bc90-47add5e58aee”
9/29/2019 1:28 PM Uncompressing “C:\WINDOWS\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup\f90f2950-1edd-4e89-bc90-47add5e58aee\XXXXX201909282207.zip” file with Internal archiver.
9/29/2019 1:28 PM Restoring “XXXXX” database from files: “XXXXX201909282207.bak”
9/29/2019 1:28 PM Failed to restore XXXXX database. Unexpected backup file extension “.bak” for server type “RemoteSqlServer”.
9/29/2019 1:28 PM Disconnecting from Folder destination “D:\Auto DB BackUP”
9/29/2019 1:28 PM Job “RESTOREJOB” finished with “1” errors