2 posts tagged with "SQL Server"

How to Restore a Database Backup Using .bak file in MS SQL Server 2008

.bak files are database backups we can restore the Database backup using SQL Server Management Studio.

A. Open SQL Server Management Studio in Object Explorer Right Click on 'Databases' Node and select 'Restore Database'

B. 'Restore Database' Dialog will be displayed on the General page

1. The name of the restoring database appears in the To database list box. To create a new database, enter its name in the list box.

2. Select 'From device'

3. Click button to display 'Specify Backup' Dialog

4. Click 'Add'  to browse the .bak file from the directory and click OK

INSTALL THE FOLLOWING IN ORDER for Windows 7 O.S

1. Microsoft .NET Framework 4 (Standalone Installer) - dotNetFx40_Full_x86_x64.exe http://www.microsoft.com/downloads/en/details.aspx?FamilyID=0a391abd-25c1-4fc0-919f-b21f31ab88b7&displaylang=en

2. Install SQL Server 2008 a. Throws firewall warning - Ignore it and proceed b. Don't open the sql server management studio

3. Download and instal SQLServer2008SP1 - SQLServer2008SP1-KB968369-x64-ENU.exe http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

4. Download and install SQLServer2008SP2 - SQLServer2008SP2-KB2285068-x64-ENU.exe http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17