FAQ

License conflict after upgrade.

Getting this error most possible because SQL Server Backup Manager has not to refresh license information from Backup Agent yet.

If your Backup Agent has been registered before the upgrade, you don't have to re-enter your license key once again after upgrade to the latest version even if the backup manager shows it is in the trial period. You just re-connect the backup agent in the "SQL Instances " configuration window to refresh the license information from the backup agent. See the following.

How to register SQL Server Backup?

Just open Backup Agent Manger and please follow steps below to register the SQL Server Backup Agent :

1 .Please make sure your current program is the latest version according to the build number, if not , please download a latest version from here .

2 .Click the "Help->Enter Registration Code" menu in SQL Server Backup Manager main window to bring up the registration form.

3 .Copy the key above in the "Registration Key" field .

How to import existing backup to new installed other sql server backup?

Import backup dose not mean importing backup to SQL Database , it just imports backup information into SQL Server Backup program inner catalog , so that it can be used in sql database restore job.

You need to import existing backup when :

  • New version of SQL Server Backup is re-installed from refresh.
  • You want to use backup that created by another SQL Server Backup.

Please follow steps below to import existing backups:

How to convert backup created by SQL Server Backup software to native raw data?

Backups created by SQL Server Backup software has own format that supports data compression and encryption.

To use them in Enterprise manager or SQL Server Managment Studio , you need to convert them to SQL Server native raw format data.

There are two ways to convert backup to raw data:

1 . By using "Convert2rawdata.exe" under installation directory , you can run it in Start->All programs ->SQL Server Backup->Storage Server->Convet Backup. See following.

How to start SQL Server in single-user mode?

Compare with user database , recovering master database is little bit different .

Before run master database restore job , you are required to start SQL Server running in single user mode.

To start SQL Server in single user mode , please do following :

1) Open "Control Panel->Administrative Tools->Services"

2) Mouse right click on specified SQL Server instance service and select "Properties" menu to bring up following service configuration window:

 

 

How to restore a sql server database to a point in time?

A very good feature for ms sql server backup software is the ability to restore database to a specified point in time.

This feature is very useful in certain circumstances.

For example ,

I have a scheduled job that performs full database backup every night at 23:00 . But today , something happened , I added some records this morning , however I deleted some usefull data accidentally at 2:00 pm.

Now the problem is :

Because I did not performed any backups during the day before 2:00 pm , the most recent backup is backup created at 23:00 last night. If I use this last night backup to restore my database, I'll lost all the data added/changed in the morning , but I want to keep work of this morning.

Thanks for ms sql server point in time recovery feature , I can restore the database to the point in time prior to 14:00 . I just need to do a transaction log backup at current moment (suppose it is 15:00) , and then I create a restore job and specify the restore point in time is 14:00 (maybe 13:59 is better) , of cause I run the restore job as soon as possbile. My work prior to 14:00 today is saved.

Although the ability to restore database to point in time is very useful , not all database can be restored to a specified point in time.

To restore a database to a point in time, the database and the backup must meet the following conditions: