Restore Database sql server 2005

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

I want to restore my Database backup file in a new created database For Example I have a db_test.bak bak file and want to restore to test_db database. please help me.

I want to restore back up through sql server 2005 query and c# .net
please help me its Urgent
I try this query
-----------------

SQL

RESTORE DATABASE test
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\db_Test.bak'
WITH MOVE 'db_Test' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf',
MOVE 'db_Test_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.ldf'

but it is not helpfull to me.
I want sql query.
Regards
Er.Hem Rah Thakur
-----------------------

thanks in advance.

Posted 29-Sep-13 18:05pm

Hem Raj Thakur

Updated 30-Sep-13 17:02pm

v3

Add a Solution

2 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)

codestar007 · Answer 1 · 2013-09-29T18:13:00

Solution 1

sql_server_2005_how_to_restore_database_backup/[^]

sql-server-restore-database-backup-using-sql-script-t-sql/[^]

Check the above links and choose according to your need..Hope it will help..

Posted 29-Sep-13 18:13pm

codestar007

Member 9822231 · Answer 2 · 2013-09-29T20:05:00

you can do this through GUI wazard.
1. Open SQL server Application.
2. Go to Object Explorer tab.
3. rt click on Database.
4. Select 'Restore files and file groups'.
5. Provide a name for new database.
6. select the radio button 'from device'.
7. locate the path of your bakup file by click on Add button in the new window.
8. select a restore source in below check box.
9. ok.