I'm relatively new to SQL Server Administration, although I have used SQL Server databases in my Access and VB applications for years.
I have SQL Server installed in my development environment. What I think I want to do is create a new named instance on that SQL Server so that when I open the Connect to Server dialog box in SSMS, it has another option "Client X", listed under the Server Names dropdown list. My goal is to be able to restore a database from a clients computer to my development machine in the Client X named instance?
Am I using the right terminology?
Is this possible? If so, what are the steps?