10-16-2013 11:27 PM - edited 03-18-2019 01:58 AM
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
Solved! Go to Solution.
10-17-2013 12:22 AM
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.
10-17-2013 12:00 AM
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.
10-17-2013 12:08 AM
Hi Jens,
Thanks for fast response,
Where I can Find SQL Management Studio, it's included in SQL Server 2008? or excluded?
Thanks,
Ovindo
10-17-2013 12:10 AM
Btw I use SQL Server 2008
10-17-2013 12:22 AM
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.
10-17-2013 01:32 AM
Dear Jens,
Thanks a lot
Ovindo.
10-17-2013 01:44 AM
It worked ok?
/jens
Please rate replies and mark question(s) as "answered" if applicable.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide