Archive for the ‘Idera’ Category

How to schedule database backups using Idera SQLSafe?

In Idera SQLSafe, to schedule database backups, you will need to create a backup policy. The following documents the steps on how it can be done:
1. Open SQLSafe Management Console.
2. Click on the “Policies” section on the left hand column.
3. If no policies existed, you will see the “Create New Policy” button on the right hand side. You can then click on the “Create New Policy” to start creating a policy. Else, right-click on the “Backup Policies” folder on the left hand column and select “Create Backup Policy…” on the popup menu.
4. On the “SQLSafe Backup Policy Wizard” screen, key in the name for the policy and key in the optional description. Under the “Action” section, select the option to “Monitor + Automatically Create Backup Jobs.” Click the “Next” button to continue.
5. On the “Membership” screen, click on the “Add/Remove Instances” button.
6. On the “Edit Instance Selection” screen, select the instance of SQL Server you wish to run backups on. Click on the “>” button to move it to the right hand pane. Click the “OK” button.
7. Back on the “Membership” screen, click on the “Choose Databases” drop-down box to select the databases.
8. On the “Edit Database Selection” screen, you can de-select to omit the database(s) from the backup policy. After you make your selection or omission. Click the “OK” button to continue.
9. Back on the “Membership” screen, click the “Next” button to continue.
10. On the “Options” screen, make your backup type choices and your compression and encryption choices. You can also select the “Include database logins in backup file” option to add the logins so that SQLSafe and restore the logins for you during restores if and when needed. Click the “Next” button to continue.
11. On the “Locations” screen, select your choices for “If Archive Exists:” and “Access Filesystem As:” if you are backing up to a remote location. Under the “Primary Archive” section, modify the backup location if necessary and specify the retention day by checking the “Remove files older than” checkbox and specify the retention days. Click the “Next” button to continue.
12. On the “Schedules” screen, specify the schedules for the backups. Click the “Next” button to continue.
13. On the “Notifications” screen, specify the actions you wish SQLSafe to take in case of failure, completion, cancellation, or other options listed. Key in the list of recipients of email addresses for the notification. You will also need to click on the “Configure Email” button if you had not configured the email settings for SQLSafe. Make sure you have the SMTP server information handy. Click the “Next” button to continue.
14. On the “Summary” screen, review the options you had selected and then click on the “Finish” button to finish.
15. You can verify the SQL Server Agent job that’s created for the policy in the instance of SQL Server you had selected to create the backup policy.

How to use SafeToSQL to extract SQLSafe backups to Native SQL Server backups?

If you need to move a backup file over to a separate network domain that will not have Idera SQLSafe installed, you can use the SafeToSQL Utility to extract and convert the SQLSafe backup file to a Native SQL Server backup file. Prior to starting, you will need to make sure SafeToSQL is installed. To verify if it’s been installed, you can go to the command prompt and browse to C:\Program Files\Idera. If you see the SafeToSQL directory, then it is installed. If it’s not installed, you can run the installation by:

  1. Run the Setup.exe in the root of the installation kit.
  2. On the Install screen, click Install SafeToSQL Utility.
  3. Accept the license agreement.
  4. Then click on the “Install” button.

You can convert a SQLSafe backup file to a Native SQL Server backup file using the following syntax:

SafeToSQL source_file_path [-backupfile file_name] [ -backupset #] [-password pwd] [-list]

If you need more explanations for the parameters, can you go to http://www.idera.com/Help/SQLsafe/7-2/web/.

In the following example, we will extract a .safe file to a .back file:

  1. On the server that has SafeToSQL installed, browse to the command prompt and the directory: C:\Program Files\Idera\SafeToSQL>
  2. Run the SafeToSQL command to extract. For example: C:\Program Files\Idera\SafeToSQL>SafeToSQL “D:\SQL_Backups\SQLsafeRepository_Full_201304251724 (1 of 1).safe”

Note that we add “” for the .safe file because it has (). You will need to add the backupset # if there are more than one and the password if it is encrypted.

REFERENCES:

SafeToSQL command
http://www.idera.com/Help/SQLsafe/7-2/web/

How to backup databases manually using Idera SQLSafe?

To backup databases manually using Idera SQLSafe you can:
1. Open the SQLSafe Management Console.
2. Under the “Servers” section on the left hand pane, expand “SQL Server Instances,” right-click on the instance you wish to backup the databases, select “Backup Database(s)…” from the pop-up menu.
3. On the “SQLSafe Backup Wizard” and on the first screen, which is the “Databases” screen, select the databases you wish to backup. Click the “Next” button to continue.
4. On the “General” screen, select the backup type and key in the “Name” and “Description” for the backups if needed. Click the “Next” button to continue.
5. On the “Locations” screen, select the “Location Type” and “If Archive Exists” options and then choose the “Primary Archive” location. Click the “Next” button to continue.
6. On the “Options” screen, select the “Compression” and “Encryption” options. You can also select the “Include database logins in backup file” under the “Advanced Options” section to restore the logins for you during the restore when needed. Click the “Next” button to continue.
7. On the “Notifications” screen, you can specify the email address(s) to get notified in case of failure or success and among other options. If the email notification system has not been configured, you will need to click the “Configure –Email” button to configure the email notification system for Idera. Make sure you have your SMTP server information handy and also the user name and password for authentication if needed. Click the “Next” button to continue.
8. On the “Summary” screen, review the location and options selected and then click on the “Backup” button to start the backup process.

How to install Idera SQLSafe Backup?

Idera is one of the well-known backup software for SQL Server. As per its website, it can backup 50% faster than native SQL Server backup and with the compression ratio up to 95%. You can also automate the SQL Server backups and restores with its backup policies. This blog post briefly documents the preparation work required.

Preparation work before you run the installation:
1. Download it from the link provided to you by the Idera and make sure you have the license key. You will need to key in the license key after the installation.
2. Location to install SQLSafe.
3. The SQL Server instance to host the Repository database. The Repository database is used to store all SQLSafe backup and restore operations, including all the file paths for the backups. If you are installing SQLSafe to manage the backups and restores for multiple instances, it is recommended that you select a dedicated instance as the central management instance.
4. Select the user account you want the Management Service to use. You can use the SQL Server service account.
5. Choose a location to store the backup files and make sure the user account for the Management Service in step 4 has permission to write to the folder.
The installation is simply filling in the blanks you had done with the preparation work. After the installation, you may want to consider installing the SafeToSQL Utility. You can use the SafeToSQL Utility to extract the Idera SQLSafe backup files to native SQL Server backup file to restore to the network domains that do not have licenses for Idera SQLSafe.

After the completion of the installation, make sure you key in the license key or else Idera SQLSafe will expire after the trial period. To key in the license key:
1. Open SQLsafe Mangement Console.
2. Click on the Tools menu.
3. Click on the “License Key Manager” option on the drop-down menu.
4. On the “License Key Manager” screen, click the “Add” button and then copy and paste the license key that the Idera Sales or Support Team had sent you. Click the “Ok” button and then the “Close” button.