Restore SQL file

We are taking ad-hoc remote backups of our Microsoft SQL server which outputs a .sql file. This doesn’t seem to restore to our SQL server which expects a .bak file. Any suggestions please to restore this file type?

Hi David_Sinclair,

If you need to restore backups with a *.bak extension, then please install the application on the same server where SQL Server is installed and use the local connection to run the backups. Otherwise only backups with the *.sql extensions are available. Please find more details at Remote SQL Server backups explained | SQLBackupAndFTP's blog

Thank you!