Other Free Encyclopedias » Online Encyclopedia » Encyclopedia - Featured Articles » Featured Articles: Mobile New Phone - Getting a New Mobile Phone to Department Of Motor Vehicles New York - How to Save Time and Money at the New York DMV - Youth Resources

Sql Server Backup Restore - How to Perform an SQL Server Backup Restore - Getting started, Performing the SQL server backup restore, After restoration

database choose restoring look

Performing an SQL server backup restore is fairly simple, even for people who do not consider themselves to be technologically minded. Of course we all understand the need to back up our files because computers can crash or get a virus at any time. An SQL server is a type of server that is made by Microsoft. It’s used for storage, and sometimes it is necessary to perform an SQL server backup restore if something goes wrong with the files or the server itself. Let’s go over the basics of restoring a backup on an SQL server.

Getting started

The first thing you will need to do is to connect to the appropriate directory. Go to the place where your servers are accessed, and click on the server name of the one you want to restore. Expand the server tree to look at the various directories within that server, and then expand the databases. If you are restoring the files for one user on the server, then select “user database.” If it’s a more serious restore that involves the entire system, then select “system databases.”

Performing the SQL server backup restore

Once you have the databases expanded, then you should be able to see exactly which part you want to restore. Highlight it, and then right click on it. Choose “Tasks,” and then go to “Restore.” When the dialogue box pops up, start on the “general” page. Make sure that the database you want to restore shows up in the “To Database” box. Next you will need to look for the box that says “To a point in time.” Always choose the most recent option, unless you know when the problem occurred and the most recent date was after the issue happened.

The next step is to choose where you want to restore the information from. You can choose either a database or a device to restore information from. After this selection, you will get the option to select a recovery plan. In most cases, you will choose the suggested recovery plan, although experienced computer programmers may choose to override that plan. To do that, just change the selections in the grid.

The next panel to look at is the “Restore Options” panel. You can either choose to overwrite what’s currently on the database, preserve the replication settings, prompt before restoring each backup, or restrict access to the restored database. The option to overwrite should only be used after careful consideration because it will overwrite everything that is currently in the database. The choice to preserve the replication settings only matters if the database was replicated when the backup was created, so the second option is not used very often either. Prompt before restoring each backup is a lengthy process, but it does allow you to look closely at each file before it is overwritten, so it is usually the best choice unless you know that the entire database is safe to overwrite. Restricting access to the restored database is only necessary in cases where you are setting up a new database for a company and you want to restrict access to the new database until it is ready to be used.

After restoration

After the SQL server backup restore is complete, then you can check the state of the recovery. Usually you will want to leave the database ready to use, unless there was a more serious problem with it.

Wheels And Casters - How to Perform General Maintenance on Wheels and Casters [next] [back] Notebook Memory Upgrade - How to Perform a Notebook Memory Upgrade

User Comments

Your email address will be altered so spam harvesting bots can't read it easily.
Hide my email completely instead?

Cancel or