Database marked as suspect please HELP!

[kurotsuke]

Hi,

I restored my Windows XP system and discovered that I cannot access a
MSDE DB that was saved in D: drive (I restored my primary partition in
C). How can I restore it?
Thanks a lot.

[getinked]

did you try reattaching it ?

[kurotsuke]

On 6 Jan 2005 10:25:09 -0800, "getinked" <gl***@imsocial.com> wrote:

did you try reattaching it ?

How can I do that? I have the MDF and LDF files but I've never done a
backup. I'm using the trial version of Teratrax Database Manager and
DbaMGR2K.
Thanks a lot for your help.

[kurotsuke]

On 6 Jan 2005 10:25:09 -0800, "getinked" <gl***@imsocial.com> wrote:

did you try reattaching it ?

I noticed the attach command in Teratrax but don't know how to use it.
It tells me

sp_attach_db 'database_name', 'file_name_and_path_relative_to_server'

Is the database_name the filename? What's the relative path? I've my
DB saved in D:\database while the server is in C:\InetPub I think.
Thanks.

[getinked]

yea the relative path would be where you are storing the data....thus
being on your D drive.

[kurotsuke]

On 6 Jan 2005 13:23:38 -0800, "getinked" <gl***@imsocial.com> wrote:

yea the relative path would be where you are storing the data....thus
being on your D drive.

Could you be more specific, what string should I enter? Thanks.

[Erland Sommarskog]

kurotsuke (ku*******@yahoo.it) writes:

On 6 Jan 2005 13:23:38 -0800, "getinked" <gl***@imsocial.com> wrote:

yea the relative path would be where you are storing the data....thus
being on your D drive.

Could you be more specific, what string should I enter? Thanks.

The exact path to where the database file is located. (The Send To Cliboard
as Name from the Win95 Powertoys comes in extremely handy here.) For
instance D:\Program Files\Microsoft SQL Server\MSSQL\Data\yourdatabase.mdf.
Note that you have two files to enter: the .MDF and the .LDF.

However, since your database is marked as suspect, it still attached
to SQL Server in some sense. You may have to drop it first. Then again,
you could attach the database under a new name.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp