SQL 2005: Dropped Database Still Exists !?!?!

[fuzzyocelot]

I have another wonderful problem that I’m stumped on. One of our tech guys is trying to re-install Vertias Backup Exec software onto one of our servers. This server is Windows 2003 SP2. We have SQL 2005 SP2 running on it. A couple of days ago he uninstalled the backup exec software because we had problems with it. Long story short, we thought we had removed every single reference to the software. So he tried to re-install it today. It says it can’t install because the BackupExec database still exists. I checked every single thing I could think of in the one SQL 2005 instance and there is no reference to this database. I checked the following and didn’t see anything referencing this database. There are no jobs or logins that exist for it either.

sys.databases
sys.database_files
sys.server_principals
select db_id('BackupExec')
sys.syslogins
sys.servers
sys.sql_dependencies
sys.all_objects
sp_helpdb


What else can I check that could be referencing this database? I've asked the tech guy to send me the exact message he's receiving. Once I have it, I'll post it.

Many thanks!!!

 

[ptheriault]

Did you check within Backup Exec? Are there any registry entries in backup exec that were left behind.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[fuzzyocelot]

He went through the registry several times and removed everything he could find referencing Backup Exec. Anyway, I spoke too soon. Apparently the tech guy was looking at the wrong server! Doh! Once I pointed that "minor" detail out to him, he tried it again and it installed just fine. Plus SQL Server is running fine too! The last time he tried anything with this software on this server the SQL services stopped running and we had all kinds of problems. Hopefully the big problems are behind us for now. (wishful thinking)

Thanks for the post, though!

 

[ptheriault]

Being on the correct server usually helps.

I'm glad you got it working.


- Paul

- If at first you don't succeed, find out if the loser gets anything.