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

Is truncate autocommit?

721


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

805


What is the difference between function and stored procedure in sql server?

689


What are the differences between web role and worker role?

116


Explain the cursor lock types?

749


Which are the third-party tools used in sql server and why would you use them?

667


Explain primary key?

728


What different steps will a sql server developer take to secure sql server?

734


What is the current pricing model of SQL Azure?

98


what is database replication? : Sql server database administration

724


Please differentiate between a local and a global temporary table?

757


How much does sql server 2016 cost?

766


How check triggers in sql server?

679


How to delete duplicate rows from table except one?

721


What are the advantages of using stored procedures?

697