In Sql 2008 R2 I could not find Security Policies. I did find Securables. I checked the GRANT check box for Create Any Database. I had to log in as SA to make that change to the user I typically use. Was this correct?
Using the link you provided, I followed the 4th choice, Restore (Transact-SQL). There I found an example link, E. Copying a Database using Backup and Restore. I was not able to understand the example provided.
I do not understand how to restore the .ndf file in the code I wrote above. See below for the source of my confusion.
I went back to trying to use SSMS to do the restore. Below are the screen shots of what I think I should set. I did not press OK.
I created a new database in SSMS, TestRestore. Then for the restore I right clicked the database and selected, Tasks>Restore>Database.
- On the General tab, Source = Device and the Backup set I created on Monday. Restore to was the new database , TestRestore
- The files tab is the source of my confusion. As you can see from the image, the ndf file has the same Original File Name AND Restore As name. Why is that? Wouldn't these setting overwrite the existing ndf that is currently being used by the Source Database? Wouldn't any changes made in the ndf between the Backup and the Restore be lost if it is over writing the Source's ndf?
- The Options tab is shown below with the options I selected. Are my choices correct?
Any help you can offer would be greatly appreciated.