Sign Up Login


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

write the query for taking database restore in sql?

Question Posted / gtp

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is resource db in sql server?

751

What is function of CUBE ?

759

Can you explain about buffer cash and log cache in sql server?

700

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

96

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

735




Explain what are magic tables in sql server?

699

What is sql collation?

828

What is difference between rownum and rowid?

669

What are the different normalization forms?

800

What is a not null constraint?

769

Explain the steps needed to create a scheduled job?

675

What is tempdb database? : SQL Server Architecture

785

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

751

What does truncate do?

698

How can you tell if a database object is invalid?

785