Is it possible to backup a remote SQL Server database to my local system? It is not working for me as I'm getting error as given below
Cannot open backup device 'path'. Device error or device offline
Any idea??
No. MSSQL only backs up locally. You could have it save to an ftp directory and download it that way.Have a good day.|||
I tried but it didn't worked. Can you post the steps here?
|||I you are using the SQL Manager use should be able to right click on the database that you wish to back up and hover over all tasks. Then select backup, This will bring up the screen for backups. On that screen click the select device button and set the device to the directory that you want to backup to. Then name the file whatever.bak. Start the backup and you are done. Open up the folder and the file will be where you selected it to save to. If that folder is available via FTP then you can download it.I hope that this helps.
No comments:
Post a Comment