You can generate CLI and T-SQL scripts for backup and restore operations through the Backup and Restore wizards. SQLsafe generates the CLI or T-SQL script using the settings you specified for the backup or restore operation.
CLI scripts can be run as a batch file from the command line prompt. Generated CLI scripts use supported options for the backup and restore actions.
T-SQL scripts can be run through Query Analyzer or as a scheduled SQL Server job. Generated T-SQL scripts leverage the SQLsafe XSP to execute backups and restores.
If you need a command line or T-SQL script for your backup or restore, SQLsafe provides the Generate Script button to let you generate CLI and T-SQL scripts for these operations. When you use a wizard to run a backup or restore, SQLsafe disables this button until sufficient criteria exists to generate a script. SQLsafe generates the CLI or T-SQL script using the settings you specified for the backup or restore operation.
How do I generate script?
You can generate script through the Backup Wizard or the Restore Wizard once your settings provide SQLsafe with enough information to create the script. Click Generate Script, and SQLsafe displays command line script by default. Click the T-SQL button and SQLsafe displays the script in T-SQL format.
To retain your script in either format, click the Save to a file or Copy script to clipboard icon. SQLsafe also allows you to use normal select, cut, copy, and paste functionality directly on the displayed script.