i have SQLBackupandFTP and remote sql server. when i try connect to remote sql server witch Microsoft sql server (sql dump) its working but create *.sql file. I need create *.bak file. When i try connect from Microsoft SQL server (standard backup)
in server name i give remote sql server ip address, and for authentication domain user pass, who have security writhes for this server, sql and folder.
then select store backup in selected destination(for example \10.10.10.25\backup) then i give backup folders \localsql\f$\sql backup and run job i have error:
[Error] Failed to backup “test” database with “Full” backup type: Backup media not found: “F:\SQL Backup\test202510011200.bak”.
destination “F:\SQL Backup\test202510011125fullcopy.bak”. is a local SQL server folder.
all security for user is writhed.
The file is actually created in the local folder and transferred to the network folder in zip format, but it gives an error and leaves the file locally on the sql server. i don’t need locally this file and i dont need zip format.
how we can resolve this issue? or how i can create bak file from remote SQL server.
another issue when i try only copy backup folder to another network shared folder SQLBackupandFTP is zipped my files. i don’t need zip format. i need only copping this bak file witch scheduler to another network folder.