Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for taking database restore in sql?
- 2 Answers
- 5551 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
In case you have filters in your report, when filters will be applied in cached report instance?
What are the advantages of sql stored procedure?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What are the recovery models for a database?
What is data source document?
How to write character string constants or literals in ms sql server?
How to disable a login name in ms sql server?
what is denormalization and when would you go for it? : Sql server database administration
Explain what are the restrictions while creating batches in sql server?
Why it is recommended to avoid referencing a floating point column in the where clause?
How will you make an attribute not process? : sql server analysis services, ssas
What are distinctive joins find as a part of sql?
How to convert numeric expression data types using the cast() function?
Can you name a few encryption mechanisms in sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
