instance lost - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

instance lost

Author

Topic

aki123
Starting Member

20 Posts

Posted - 2007-08-19 : 05:24:33

hi

i lost one of my instances.

i guess instance is also a database engine,
and has its own sevice runing.

on server 2000 sp4 sqlexpress.

i had 3 of them, now i have only 2.
it was servername, servername\bkupexec and servername\sqlexpress
the last one dont exist anymore.

yet the application that depands on the last one
have now problem.
it seems that now its working on the first instance.
i see the database on it.

i wonder how could it happen?
and could it make a preformance problem.
i dont see any performance issue yet.

thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-19 : 07:27:11

You can tell by investigating the %Program Files%\Microsoft SQL Serverdirectory. How many subdirectories do you have?

Maybe the last instance has not started?

E 12°55'05.25"
N 56°04'39.16"

aki123
Starting Member

20 Posts

Posted - 2007-08-19 : 07:36:22

hi again

well, looking at the services, i have notice
that they changed.
now i have
mssqlserver instead of sqlexpress
dont have the sql server ad helper
dont have the sql server agent

i know that beacuse i restore the server
to another machine in lab invironment.

yet dont understand how it become.
no issue yet. no perormance issue.
sqlexpress can be load, and i can see the app database.

thanks

aki123
Starting Member

20 Posts

Posted - 2007-08-19 : 08:24:11

hi peso

has u mentioned i checked the sql directory.
i had 80, 90, mssql, mssql$bkupexec, mssql.1
now i have 80, 90, mssql$bkupexec, mssql.1

i thought mssql is sql2000 directory.
but i have issue with 2005 express

thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-19 : 15:27:34

80 is for SQL Server 2000, 90 is for SQL Server 2005.
What's important is the xx.1 and xxx.2 directories.

It seems to me you have two instances installed.

E 12°55'05.25"
N 56°04'39.16"

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-19 : 17:01:14

Looks like your app is talk to default instance. Did anyone rebuild server?

aki123
Starting Member

20 Posts

Posted - 2007-08-21 : 08:22:38

quote:
Originally posted by rmiao

Looks like your app is talk to default instance. Did anyone rebuild server?

hi

yes you right.
my app that talk to the instance named sqlexpress
now talk to the default.

how can it be changed?
the only thing i did is update bkupexec 9 to 9.1

thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources