write the query for taking database restore in sql?
- 2 Answers
- 4971 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
What is data file in computer?
Describe in brief system database.
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Why we use the openxml clause?
What is @@rowcount in sql?
How to perform backup for certificates in sql server? : sql server security
Can coalesce return null?
what is denormalization? : Sql server database administration
What is normalization? Explain different forms of normalization?
How to provide default values to stored procedure parameters?
What is a partitioned view?
Why de-normalization required?
What is the difference between createstatement and preparedstatement?
Is it possible to call a stored procedure within a stored procedure?
Tell me what are cursors and when they are useful?
