Remote / Hosted SQL Server backup using scripting
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. You get one or several *.sql files with CREATE, INSERT T-SQL statements
that recreate database.
Remote backup feature is in permanent Beta because 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. See below for specific DB objects.
You can discuss remote backups on forum.
SQL objects supported by SQLBackupAndFTP script backup
|
SQL objects & features
|
Supported
|
|
Database creation with its properties (collate, compatibility, ANSI padding, ANSI
warnings, arithabort, autoclose, auto create statistics, auto shrink, auto update
statistics, set cursore close on commit, set cursor default, concat null yields
nulls, numeric round abort, quoted identifier, recursive triggers, broker, auto
update statistics async, date correlation optimization, trustworthy, allow snapshot
isolation, parametrization, readonly, recovery, page verify, db changing)
|
|
|
Database roles
|
|
|
Database schemas
|
|
|
Database users
|
|
|
Database tables structure (tables with columns, their datatypes, identities, unique
constraints, collation, persisted, not for replication, allow nulls, computed columns
and computing expressions)
|
|
|
Tables data
|
|
|
Foreign keys and relations
|
|
|
Table triggers
|
|
|
Database triggers
|
|
|
Database stored procedures
|
|
|
Database user functions
|
|
|
Database views
|
|
|
User defined data types
|
|
|
Principal Permissions
|
|
|
Users to roles mapping
|
|
|
Check constraints
|
|
|
Fulltext catalogs
|
|
|
Fulltext indexes
|
|
|
Database xml entities
|
|
|
Database diagrams
|
|
|
Extended properties
|
|
Download SQLBackupAndFTP Free
Windows web site hosts SQL backup support
At the very basic level most of the hosters have their own web-based tools
for automating SQL server database backups
Only some of the web hosts support connecting to a database from the client
computer (using SQL Management Studio or SQLBackupAndFTP). You can use SQLBackupAndFTP
scripting only on the sites that support it.
Windows web site hosts without SQL Server support
The hosts in the list below do not have Windows or SQL Server support
Download SQLBackupAndFTP Free