How to backup remote SQL Server database using SQLBackupAndFTP

You can run scheduled backups of a remote SQL server using SQLBackupAndFTP. The standard BACKUP DATABASE command would not work on a remote SQL Server, so scripts would be the only option. Scripts are not as good as *.bak files because they are larger, do not support differential backups and should be used only if you do not have an option to create *.bak files. If you want to know more – read a good explanation why remote SQL backups are such a pain. More…

Backup SQL Server on the network

SQLBackupAndFTP  creates standard *.bak files when it runs locally on the same computer where SQL Server is. For remote SQL Server computer backups SQLBackupAndFTP creates backup script files (*.sql). Whenever possible, you should always opt for *.bak backups against *.sql backup files.

Here we will show you how to backup a SQL Server on the network to the standard *.bak file even when SQLBackupAndFTP runs on a different computer from where SQL server is. The main requirement in this case is that both SQL server and SQLBackupAndFTP have access to the same shared network folder.

More…

Cloud Databases for Busy People

This post will give you a bird’s eye view explanation of what “cloud database” is and what kinds of cloud databases the market offers us today. More…

SqlBackupAndFtp Discount Coupon

If you’re looking for a promo code for SqlBackupAndFtp you can use the following one:

SBF10OFF

It will give you 10% off all editions of SqlBackupAndFtp.

Customize backup file name

By default SQLBackupAndFTP stores backups in file names like DatabaseNameYYYYMMDDHHMM.zip (eg Pubs201801011120.zip). But you can also use custom file names if you have such needs More…

«< 3 4 5 6 7 >»

Support button

?

↑

© SQLBackupAndFTP's blog 2020
Powered by WordPress • Themify WordPress Themes