Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to 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
-----------------
 
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
Edited 30-Sep-13 17:02pm
v3
Rate this: bad
good
Please Sign up or sign in to vote.

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..
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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.
  Permalink  

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

  Print Answers RSS
0 Dnyaneshwar@Pune 1,300
1 Sergey Alexandrovich Kryukov 667
2 Tadit Dash 350
3 ravikhoda 300
4 Manas Bhardwaj 240
0 Sergey Alexandrovich Kryukov 11,224
1 OriginalGriff 6,897
2 Peter Leow 4,795
3 Abhinav S 3,838
4 Maciej Los 3,575


Advertise | Privacy | Mobile
Web01 | 2.8.140421.2 | Last Updated 30 Sep 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid