How to Delete TMSPE (SQL database tmspe) - TMS

[Ovindo Prastyo Utomo]

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,

Please advise.

Thanks,

Ovindo

[Jens Didriksen]

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.

[Ovindo Prastyo Utomo]

Hi Jens,

Thanks for fast response,

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

Thanks,

Ovindo

[Ovindo Prastyo Utomo]

Btw I use SQL Server 2008

[Jens Didriksen · Accepted solution]

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.

[Ovindo Prastyo Utomo]

Dear Jens,

Thanks a lot

Ovindo.

[Jens Didriksen]

It worked ok?

/jens

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