Worldtechies

I was wondering how to restore BAK files using query Analyzer as most of the hosting services will provide query Analyzer.

I got a script which works wonder and it’s damn simple.

1. create .bak file using Enterprise Manager

2. Store that in some location

3. Open Query analyzer and execute below command.

Use Master
Alter Database db_Name
SET SINGLE_USER With ROLLBACK IMMEDIATE

RESTORE DATABASE db_Name
FROM DISK = ‘D:\dbName.bak’

That’s it here we go………..

One more solution is installing third party software http://www.sqlscripter.com/

• SQL stands for Structured Query Language
• SQL allows you to access a database
• SQL is an ANSI standard computer language
• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert new records in a database
• SQL can delete records from a database
• SQL can update records in a database
• SQL is easy to learn