IN SQL SERVER 2005:--> RESTORE DATABASE database name FROM DISK =&#

write the query for taking database restore in sql?

Question Posted / sandeep thakur

2 Answers
5668 Views
I also Faced
E-Mail Answers

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

Do you know what is difference between index seek vs. Index scan?

994

How to change the ownership of a schema in ms sql server?

1251

How do you size a resultset?

959

Who is the owner of a schema in ms sql server?

1114

What is Lock table in SQL?

1517

What is the use of =,==,=== operators?

1057

Can we check locks in database? If so, how can we do this lock check?

984

How can i Relate Tables in SSIS

1134

What happens if null values are involved in boolean operations?

1038

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1115

What is forward - only cursors / read only cursor?

1128

What happens if null values are involved in string operations?

1026

Is it possible in sql table to have more than one foreign key?

1090

What is sql or structured query language?

1190

Write SQL queries on Self Join and Inner Join.

1212