Most frequently asked questions

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

To restore a SQL Server database to point of failure, the database's recovery model should not be "Simple", because it needs a transaction log backup to do that, "Simple" recovery model does not have a 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 the database to the point of failure :

1). Back up the tail of the transaction log after SQL Server fails.

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:

 

 

I get "Access is denied" error when I back up SQL server database 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 . )

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