Page History
SQLsafe SQL Safe provides a robust, easy-to-use SQL Server database backup and restore solution. Behind a simple user interface, SQLsafe SQL Safe offers an architecture that is both flexible and extremely powerful. SQLsafe SQL Safe fits your environment, no matter how simple or complex.
The SQLsafe SQL Safe architecture easily runs in your SQL Server environment with minimal configuration. All SQLsafe SQL Safe components run outside and separate from SQL Server processes. SQLsafe SQL Safe does not add to or modify any of your native SQL Server files or services. After you install these components, you can implement features such as Reports.
...
The Management Console also provides a T-SQL generator, allowing you to create backup and restore T-SQL scripts. You can execute these scripts through scheduled SQL Server jobs or combine several scripts into a single SQL Server scheduled batch job.
Repository Database
The SQLsafe SQL Safe Repository (Repository) is a central database that tracks all SQLsafe SQL Safe backup and restore operations and the corresponding backup archive file paths for your enterprise.
...
The Management Service receives events from the Backup Agent, and then relays the status of all current and completed operations to the SQLsafe SQL Safe Repository.
Backup Agent
The Backup Agent performs backup and restore operations. The agent is a service that runs on the target SQL Server computer.
...
Command-line Interface and Extended Stored Procedures
The SQLsafe SQL Safe command line interface (CLI) and extended stored procedures (XSPs) allow you to execute SQLsafe SQL Safe backup and restore procedures with batch files or through your preferred scripting language. You can also use the CLI or XSPs as an alternative to the Management Console.
For sample XSP scripts, see the Sample Scripts programs menu shortcut (Start > All Programs > Idera > SQLsafe SQL Safe > XSP > Sample Scripts). The following scripts are available:
...
The following diagram illustrates the components of the SQLsafe SQL Safe architecture.
SQL
...