Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for taking database restore in sql?
- 2 Answers
- 5400 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 difference between cte and view?
How can you find out which stored procedures are recompiling?
What is transaction server auto commit?
Can we return Data from 4(more than 1) tables in stored procedure?
What is a transactions?
Can a trigger be created on a view?
Explain cursor as data base object?
What is subquery in sql?
Why use “pivot” in sql server?
What is the security principal at the server level that represents your session?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How you can get a list of all the table constraints in a database?
How to turn on the mssql api module in php?
Where are full-text indexes stored?
What is a ddl statement?
