Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

How to Delete TMSPE (SQL database tmspe) - TMS

Hi,

I just try to uninstall TMSPE and after that try to reinstall TMSPE, but it say "Database 'tmspe' cannot be opnened. It has been marked SUSPECT by recovery."

How can I reinstall TMSPE if the database tmspe marked SUSPECT?

TMS version      : 14.3.0

TMSPE version  : 1.1

Below screeen capture,

TMSPE.png

Please advise.

Thanks,

Ovindo

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to Delete TMSPE (SQL database tmspe) - TMS

I'm using 2008 R2:

but you can download SQL Server Management Studio Express from Microsoft, it's free

http://www.microsoft.com/en-au/download/details.aspx?id=7593

Mind you, if you're a bit uncomfortable making these kind of changes, then I would seriously consider opening a case with TAC.

/jens

Please rate replies and mark question(s) as "answered" if applicable.

Please rate replies and mark question(s) as "answered" if applicable.
6 REPLIES

Re: How to Delete TMSPE (SQL database tmspe) - TMS

I would've thought it would've asked if you wanted to use the existing db or create a new one. but maybe not.

RDP to the server where tmpse db is installed, open SQL Server Management Studio, then expand the database folder in the left pane, select tmpse database and delete it.

Re-install TMSPE and rebuild the database all over again.

/jens

Please rate replies and mark question(s) as "answered" if applicable.

Please rate replies and mark question(s) as "answered" if applicable.

How to Delete TMSPE (SQL database tmspe) - TMS

Hi Jens,

Thanks for fast response,

Where I can Find SQL Management Studio, it's included in SQL Server 2008? or excluded?

Thanks,

Ovindo

How to Delete TMSPE (SQL database tmspe) - TMS

Btw I use SQL Server 2008

Re: How to Delete TMSPE (SQL database tmspe) - TMS

I'm using 2008 R2:

but you can download SQL Server Management Studio Express from Microsoft, it's free

http://www.microsoft.com/en-au/download/details.aspx?id=7593

Mind you, if you're a bit uncomfortable making these kind of changes, then I would seriously consider opening a case with TAC.

/jens

Please rate replies and mark question(s) as "answered" if applicable.

Please rate replies and mark question(s) as "answered" if applicable.

How to Delete TMSPE (SQL database tmspe) - TMS

Dear Jens,

Thanks a lot

Ovindo.

How to Delete TMSPE (SQL database tmspe) - TMS

It worked ok?

/jens

Please rate replies and mark question(s) as "answered" if applicable.

Please rate replies and mark question(s) as "answered" if applicable.
304
Views
0
Helpful
6
Replies
CreatePlease to create content