What is the use of MOVE keyword in restore command

Answer Posted / murthy

Can use MOVE to specify to restore the DB & log to the
specific file path instead of restoring it into its
original location.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain encryption of entire databases without the need for application changes in sql server 2008?

555


What are the steps to take to improve performance of a poor performing query? : sql server database administration

596


Explain the creation and execution of a user-defined function in the sql server?

570


How to view existing indexes on an given table using sp_help?

588


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2106






You want to implement the one-to-many relationship while designing tables. How would you do it?

498


Explain the Ways to improve the performance of a sql azure database?

64


What is a partitioned view?

557


What should be the fill factor for indexes created on tables? : sql server database administration

617


How to drop an existing user defined function in ms sql server?

556


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

560


How can we migrate from SQL server to SQL Azure?

92


How to create “dependant” parameter “make, model, year”

87


What are the new features of sql server 2008 r2 reporting service?

110


What is the meaning of sql server?

524