You are here

Most frequently asked questions

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:


How to restore sql server database to the point of failure?

To restore a sql server database to point of failure , database's recovery model should not be "Simple" , because it needs transaction log backup to do that , "Simple" recovey model dose not have transaction log.

If your database's recovery modal is "Simple" , you can not restore to the point of failure , in this case , please select the latest differential and full backup do the restore. If your database's recovery modal is not "Simple" , to restore database to the point of failure :

I get "Access is denied" error when I back up sql server datebase to a network shared folder.

Storage server saves backup to target shared folder , but Storage Server service is running as Local System account in default . Local System account may not have enough privileges to access the network shared folder. So you can change DataBK Storage Server service account to a new one in in Control Panel->Administrative Tools->Service , see following : (Please note that : Server that shares the folder should also has the same account name and password . )

I cannot see the sql server instances ,it says the server is not running. Any help?

First of all ,backup agent should be installed on the ms sql server computer. (for more inforation , please visit SQL Server Backup Software Architectural Overview page)

If you installed backup agent on the sql server machine , and still no instance listed in configuration window , please do following :

Firewall settings for SQL Server Backup

Default ports for SQL Backup software are 6000 for SQL Backup Agent and 6001 for SQL Storage Server ,both ports are TCP port . Please make sure these ports are not blocked by firewall. If these ports are used by another program , you can change them in Backup Agent Manager and Storage Server Manager .

Microsoft SQL Server 2012 backup and restore supports

SQL Server Backup is able to back up and restore the latest Microsoft SQL Server 2012. When you configure the backup instance , please select a correct sql server edition.

And this software is also able to restore sql server 2005 and/or 2008 backup to sql 2012 server, it is very easy to do that, just define a new restore job to migrant an early version database to SQL 2012 server.

microsoft sql server 2012 backup and restore supports

Subscribe to RSS - Most frequently asked questions