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

Explain about builtinadministrator?

0 Answers  

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  

How do I install sql server?

0 Answers  

why would you use sql agent? : Sql server database administration

0 Answers  




How do you read transaction logs

1 Answers  

Explain what are page splits? : SQL Server Architecture

0 Answers  

what is diffence between replicaion and logshipping?

1 Answers  

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

What is the use of sql profiler in sql server 2012?

0 Answers  

What is ddl and dml commands?

0 Answers  

What is sql collation?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories