Thanks Erland, I will use View based approach.

Thanks a lot Mr. Williams and Mr. Schripsema,

I will get the local path on the server to restore the files and restore the database accordingly.

Once again thank you for your...

Thanks, but that is not my requirement. My requirement is to restore on the network location.

I am getting following error:

The file "\\ServerB\Files\Data_Primary.mdf" is on a network path that is not supported for database files.

'DB_Data' can not be restored to '\\ServerB\Files\Data_Primary.mdf'. Use WITH MOVE to identify...