SQL Server Backup Topics

If the database is created after master is backed up ,new restored can no be seen in managment studio/enterprise manager, because master backup set has no informaton about the new database, after master is restored , the user database will not be known to SQL Server.

In this case , if all database files comprising the user database still exist on the disk(s), the user database can be created by attaching the database files .
Just open the Query Analyzer , and then execute the following sql statements: (we attach pubs database as sample)

To restore database with new database name , please configure a restore job with following settings:

(Suppose the original name is db1 and the target database name is dbx)

1 . Select the restoration target Backup Agent and Instance ,then just enter new database name in "Restore As" field .(we enter the "dbx"), see following :

Yes, you just convert DataBK backups to Microsoft SQL Server raw backup at first, and then use it in Microsoft SQL Server's Query Analyzer. To convert backup to raw data, please click the "Backup Convert" button, and then follows it's an instruction to do this work.

SQL Server Backup license is server base , One server(computer) per license. and Only DataBK SQL Backup Agent requires a license to run.

SQL Server Backup software includes three programs : DataBK Backup Manager , DataBK SQL Backup Agent , DataBK Storage Server .(For more detail information , please click here.)

DataBK Backup Manager and DataBK Storage Server dose not require license.

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.

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 .

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:

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.

Yes, you can run sql server backup or restore job in command line mode . For detail information about command line usage , please visit Command Backup/Restore walkthought.

All job reports can be found in "Job report" window , just mouse right click on a job node , you'll see all this job's history report . see following file attached. if you can not see the latest reprt , please click "Refresh" button .