write the query for taking database restore in sql?
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
Give an example of SQL injection attack ?
what is database replication? : Sql server database administration
How to delete duplicate rows in sql server?
What are the properties and different types of sub-queries?
What are ddl (data definition language) statements for tables in ms sql server?
What stored by the model? : sql server database administration
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Find columns used in stored procedure?
What does it mean to normalize data?
How do users use Report Builder with SQL Server data sources?
What is identity?
How to retrieve error messages using odbc_errormsg()?
Explain an automatic checkpoint
Which are new data types introduced in sql server 2008?