How do restore the backup from backup file?

Question

0.00/5 (No votes)

See more:

ASP.NET

SQL-Server

, +

How to restore the database from existing backup file?

Posted 10-Mar-14 18:03pm

Ni!E$H_WAGH

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aravindba · Accepted Answer · 2014-03-10T18:09:00

Solution 1

Hai

Try this links

http://technet.microsoft.com/en-us/library/ms177429.aspx[^]

http://technet.microsoft.com/en-us/library/ms187048.aspx[^]

http://technet.microsoft.com/en-us/library/ms187048.aspx[^]

http://www.youtube.com/watch?v=fohy0bpz1A4[^]

https://www.google.co.in/?gfe_rd=ctrl&ei=FoweU5_6MeqJ8Qejp4GoCw&gws_rd=cr#q=restore+backup+in+sql+server+2008[^]

Posted 10-Mar-14 18:09pm

Aravindba

Comments

Ni!E$H_WAGH 11-Mar-14 1:44am

Thanks Aravindba.

Aravindba 11-Mar-14 1:53am

u r welcome

SanSkun · Accepted Answer · 2014-03-10T18:40:00

Solution 2

Hi,
Open SQL Server.Locate the path,where the backup file is present.Now right click on database->select Restoredatabase.Then one pop up window will open.Now select one radio button name from device,then browse for backup file name "yourdatabasename.bak". Then click OK. That's it.Now your database will available in left pane under database.

Posted 10-Mar-14 18:40pm

SanSkun

Comments

Ni!E$H_WAGH 11-Mar-14 1:43am

Thanks Santosh Kumar Chhotaray945 .

SanSkun 11-Mar-14 2:16am

Most welcome......

TusharBharambe · Accepted Answer · 2014-03-10T20:10:00

SQL

To restore a database to a new location, and optionally rename the database

    Connect to the appropriate instance of the SQL Server Database Engine, and then in Object Explorer, click the server name to expand the server tree.

    Right-click Databases, and then click Restore Database. The Restore Database dialog box opens.

    On the General page, use the Source section to specify the source and location of the backup sets to restore. Select one of the following options:

       1- Database

       2 - Device
Click the browse (...) button to open the Select backup devices dialog box. In the Backup media type box, select one of the listed device types. To select one or more devices for the Backup media box, click Add.

After you add the devices you want to the Backup media list box, click OK to return to the General page.

In the Source: Device: Database list box, select the name of the database which should be restored.

In the Destination section, the Database box is automatically populated with the name of the database to be restored. To change the name of the database, enter the new name in the Database box.

In the Restore to box, leave the default as To the last backup taken or click on Timeline to access the Backup Timeline dialog box to manually select a point in time to stop the recovery action. See Backup Timeline for more information on designating a specific point in time.

In the Backup sets to restore grid, select the backups to restore. This grid displays the backups available for the specified location. By default, a recovery plan is suggested. To override the suggested recovery plan, you can change the selections in the grid. Backups that depend on the restoration of an earlier backup are automatically deselected when the earlier backup is deselected.

For information about the columns in the Backup sets to restore grid, see Restore Database (General Page).

To specify the new location of the database files, select the Files page, and then click Relocate all files to folder. Provide a new location for the Data file folder and Log file folder. For more information about this grid, see Restore Database (Files Page).

On the Options page, adjust the options if you want. For more information about these options,