You can generate CLI and T-SQL scripts for backup and restore operations through the Backup and Restore wizards. SQL Safe 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 SQL Safe XSP to execute backups and restores.

If you need a command line or T-SQL script for your backup or restore, SQL Safe 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, SQL Safe disables this button until sufficient criteria exists to generate a script. SQL Safe 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 SQL Safe with enough information to create the script. Click Generate Script, and SQL Safe displays command line script by default. Click the T-SQL button and SQL Safe 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. SQL Safe also allows you to use normal select, cut, copy, and paste functionality directly on the displayed script.

 

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
  • No labels