Can use MOVE to specify to restore the DB & log to the specific file

What is the use of MOVE keyword in restore command

Question Posted / murthy

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

Please Help Members By Posting Answers For Below Questions

What are the purposes and advantages stored procedure?

1020

What is a natural primary key?

1112

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1138

Can you explain what are commit and rollback in sql?

986

Explain the cursor lock types?

1101

How do you manipulate data?

949

what are the new features introduced in sql server 2000? : Sql server database administration

980

What is the difference between resultset and resultsetmetadata?

1032

What is inner join? Explain with an example?

1289

What is user-defined multi-statement table-valued function?

1120

Explain can SSRS reports Cache results?

161

What is the purpose of data source?

1093

What are the joins in sql server? : sql server database administration

1050

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

2001

What is nolock?

1039