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

write the query for taking database restore in sql?

Question Posted / sandeep thakur

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sub-query in sql server?

664

If user is owning any SQL Objects, can we drop that user

1602

Explain how to use linked server?

560

What are the advantages of stored procedure in sql server?

463

Explain what are the basic functions for master, msdb, model, tempdb databases?

524




What is federation member?

91

What stored procedure can you use to display the current processes?

490

Can we perform backup restore operation on tempdb?

563

What are the elements of dbms?

539

what are isolation levels? : Sql server database administration

495

Is there any difference between primary key and unique with the not null condition?

523

What are the transaction properties?

547

How do I know if localdb is running?

507

How to create hyperlink from returned sql query ?

618

What is the simplest way to create a new database in ms sql server?

531