1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

write the query for taking database restore in sql?

Question Posted / hari

Answers were Sorted based on User's Feedback



write the query for taking database restore in sql?..

Answer / gtp

RESTORE DATABASE NewDatabase
FROM DISK='D:\Backup\NewDatabase.bak'
WITH
MOVE 'NewDatabase' TO 'D:\ActiveDB\NewDatabase.mdf',
MOVE 'NewDatabase_log' TO 'D:\ActiveDB\NewDatabase_log.ldf'

Is This Answer Correct ?    4 Yes 0 No

write the query for taking database restore in sql?..

Answer / sandeep thakur

IN SQL SERVER 2005:-->

RESTORE DATABASE database name FROM DISK
='E:\Dailybackup\backupname.bak'
WITH MOVE 'database name' TO 'D:\database\databasename.mdf',
MOVE 'database name' TO 'D:\database\databasename.ldf',
REPLACE

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are approximate numeric data types in ms sql server?

0 Answers  

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

What is the usage of the sign function?

0 Answers  

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  




What are points to remember while using the fillfactor argument?

0 Answers  

What is an index. What are the types?

0 Answers  

What are the purpose of Normalisation?

0 Answers   HCL,

What are the different types of replication? How are they used?

3 Answers  

How does recursive cte works in sql server?

0 Answers  

What is a trigger what are the advantages of trigger?

0 Answers  

How to configure odbc dsn with different port numbers?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories