What is the use of MOVE keyword in restore command

Question Posted / chaithanya

Answers were Sorted based on User's Feedback

What is the use of MOVE keyword in restore command..

Answer / andy

to move physical files to physical path.

Is This Answer Correct ?

3 Yes

0 No

What is the use of MOVE keyword in restore command..

Answer / c suresh kumar

using move statement we can store the resultent value

Is This Answer Correct ?

3 Yes

2 No

What is the use of MOVE keyword in restore command..

Answer / 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

More SQL Server Interview Questions

What are magic tables in sql server?

How to swap the data of two columns in a table. both the columns containing varchar values.

What is data block and how to define data block size?

What command is used to delete a table from the database in the sql server and how?

List out the different types of locks available in sql server?

What are the underflow and overflow behaviors on float literals?

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

What is the difference between system objects and user objects?

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

Where do you find the default Index fill factor and how to change it?

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

What are different types of Keys? Please explain all the keys with a suitable example.

For more SQL Server Interview Questions Click Here