How can we help you today? How can we help you today?

Urgent, Please Help. SQL Server 2019 Named Instance Question

Hello all,

I just installed a new named instance on SQL Server 2019 RTM-CU32.  The installation was successful but when I connected to the new named instance, it had all the databases and data from the default instance.  I looked at the properties of a couple databases and both instances (default and named) point to the same data and log files.

I've installed named instances in the past (several years ago) and didn't have this problem.

I suspect that somewhere in the configuration of setup, it asked me for file locations and I missed it.

So, I have 3 questions:

  1. Can I salvage the newly installed named instance and just point to new data and log files?
  2.  Can I uninstall the newly created named instance without effecting the current default instance?  The default instance is a mirror of the production databases and is used for data analysis, etc.
  3. If I have to reinstall the named instance, where in the setup configuration do I find the setting(s) about data and log file locations?

Basically, How do I fix this?

Of course, all of these options would have to be done without effecting the current default instance.

I'm leaving town Tuesday, 6/10 for a week and I need to get this named instance set up before I leave if possible.

Please let me know if you have any questions.

Thank you in advance for your help.

Brett Walker

Brett
0

Add comment

Please sign in to leave a comment.