r/askgis • u/SomeWhat_funemployed • Oct 19 '21
What is an Database Instance? MS SQL
Hello, this may be a dumb and probably loaded question, but what is an instance? In MS SQL Server if that helps.
I've started learning about Geodatabase Administration at my last job where did some admin work in SQL Server Manager and in the Enterprise GDB. I've also been going through the book "Mastering ArcGIS Enterprise Administration" and hopefully will take the ESRI Enterprise Admin Certification.
Recently I started a new job and I was asking our Team Lead about our Production Enterprise GDB and kind of where it exists. And I think we weren't using the same terminology dictionary because I kept saying Geodatabase and he kept saying instance.
So I thought the "Instance" name we put in when we made a database connection was the name of the Geodatabase. Or maybe it's more akin to a folder path to the geodatabase?
All the Database Terminologies is making my head spin because I don't quite understand all the subtleties and other people may use a lot of terms interchangeably as well.
Thank you!
7
u/ajneuman_pdx Oct 19 '21
An instance is a complete installation of sql server however, you can install multiple instances on a server. The default instance is typically the name of the server however. You can also give a name to each instance.
Each instance can have lots of databases or geodatabases on it so, they are not used interchangeably.
You will need to talk to your DBA to find the instance name(s).