You are here


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:


Can I use backups in Microsoft SQL Server's Query Analyzer?

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 instruction to do this work.

How to restore database with a new database name?

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 :

After I restore the master database , a database is missing.

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)

How to rebuild master database?

Different edtion of SQL Servers have different ways to rebuild master database. For SQL Server 2000 , in the installation directory , there is a program named rebuildm.exe ,(If you can't find it , you have to find it on MS website) you start this program and follow it's instructions to rebuild the master database .

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 :

How to restore backup onto a fresh system?

If you start from a new installed system (os ,db , reinstall), you can restore the database by doing following steps:

1 . Install SQL Server Backup on new system .

2 . Prepare and import backups to new installed SQL Server Backup , a latest full backup and it's later backups required.

import backup

Subscribe to RSS - Restore