Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for taking database restore in sql?
- 2 Answers
- 5676 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
What is global temp table?
What are the 7 disadvantages to a manual system?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How can windows applications connect to sql servers via odbc?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
Tell me about pre-defined functions of sql?
What is server-level principal?
Define synonym?
Distinguish between nested subquery and correlated subquery?
How to replace the Query Result 'Null Value' with a text ?
Explain the difference between cross join and full outer join?
what is a join and explain different types of joins? : Sql server database administration
What is an active database?
What is the difference between createstatement and preparedstatement?
