Yes, it should work. The database will be restored as 'Data_test' and the files on disk will be called Data_Test1.mdf, etc.

In SSMS, if you start a restore, select all the files from the backup set, do the renaming of physical files, etc. tick the right boxes, you can then click the 'Script' button at the top of the window to see what the TSQL is like. You can then edit
it from there.

Yes, it should work. The database will be restored as 'Data_test' and the files on disk will be called Data_Test1.mdf, etc.

In SSMS, if you start a restore, select all the files from the backup set, do the renaming of physical files, etc. tick the right boxes, you can then click the 'Script' button at the top of the window to see what the TSQL is like. You can then edit
it from there.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.