MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
How does remote SQL Server backup work? Options · View
#1 Posted : Thursday, July 7, 2011 9:17:09 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 437
When installed locally, SQLBackupAndFTP backs up databases using BACKUP DATABASE command. You get a single *.bak file that you can restore using RESTORE DATABASE command.

For remote or hosted SQL Server instances (where you can connect to these instances using SQL Management Studio) - SQLBackupAndFTP backs up databases using scripting ("remote backup"). You get one or several *.sql files with CREATE, INSERT T-SQL statements that recreate database. You generally can not use BACKUP DATABASE command for remote servers because backup file would be created on that remote server and getting it to you local PC would be problematic.

Remote backup feature is in permanent Beta because of the complexity of the task. There's no harm of damaging the existing database during backup, but we can not guarantee your restore 100%. You should try the restore for yourself. Use Remote only if Local installation is not possible. Note that SQL Server 2000 is not supported for remote backup, all other versions are supported.
For more info, see remote backup
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups