Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for taking database restore in sql?
- 2 Answers
- 5513 Views
- I also Faced
- E-Mail Answers
Answer Posted / gtp
RESTORE DATABASE NewDatabase
FROM DISK='D:\Backup\NewDatabase.bak'
WITH
MOVE 'NewDatabase' TO 'D:\ActiveDB\NewDatabase.mdf',
MOVE 'NewDatabase_log' TO 'D:\ActiveDB\NewDatabase_log.ldf'
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Do you know what are various aggregate functions that are available?
What does dml stand for?
What are the hotfixes and patches in sql server?
How can we use ConnectorJ JDBC Driver with MS SQL?
what stored procedure can you use to display the current processes? : Sql server administration
Do you know data definition language, data control language and data manipulation language?
Can truncate be rolled back?
How to delete duplicate rows from table except one?
What do you understand by triggers and mention the different types of it?
How many categories of functions based their return modes?
What are subqueries in sql server? Explain its properties.
What is Dependency Injection and provide example?
What is the use of =,==,=== operators?
What is server-level principal?
What are window functions in sql server?
