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
5515 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

Define magic tables in sql server?

1036

What are the purposes of floor and sign functions?

957

How to retrieve error messages using mssql_get_last_message()?

1031

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1016

Can truncate be rolled back?

918

What is data compression? : sql server database administration

956

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

981

How to display a past time in days, hours and minutes?

1005

List the advantages of using stored procedures?

1031

What are SSL and TSL protocols?

966

Do you know what is lock escalation?

994

What are the advantages of using a stored procedure?

991

How to create stored procedures with parameters in ms sql server?

1048

Why we use trigger in sql server with example?

945

Do you know the policy based administration feature of sql server 2008?

936