getting instance name

Question

getting instance name

shinobigoh

Ten Centuries

Points: 1072
More actions
April 13, 2010 at 10:08 pm

#231675

my sql server 2000 database crashed
do u know any way to get the instance and database name without querying

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

shinobigoh (4/13/2010)
my sql server 2000 database crashed
do u know any way to get the instance and database name without querying

You dont remember your instance name and database name?

for database names, check out from your past backups.

for instance names, u'll need to browse through registry..

Pradeep Singh

McSQL SSCarpal Tunnel Points: 4936 More actions · Answer 2

If by crashed, there was not a major system issue, and SQL is still runnable, then right click on my computer and go to "manage" then check your services.

If there was more than one instance, the SQL Agent Service should display as(if it was set up with the default name):

"SQLAgent$XXX" (where xxx is the instance name.

I'm assuming MSSQL is not up and running anyway and it is not as straightforward as using Enterprise Manager to connect to the server and instance to browse the databases on the instance??

If you elaborate further on the "crash" you experienced I can run through ways to check for both.

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

I agree with Ian, checking the services is a pretty easy way to determine the instance names. If they are not specified, then you have the default instance installed. As for database names, if the directory where the database files are stored is not damaged, you may be able to get a general idea of what the database names are from the file names, unless the logical names were named completely different.

Joie Andrew
"Since 1982"