By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,163 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Database marked as suspect please HELP!

P: n/a
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.
Jul 23 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
did you try reattaching it ?

Jul 23 '05 #2

P: n/a
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.
Jul 23 '05 #3

P: n/a
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.
Jul 23 '05 #4

P: n/a
yea the relative path would be where you are storing the data....thus
being on your D drive.

Jul 23 '05 #5

P: n/a
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.
Jul 23 '05 #6

P: n/a
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
Jul 23 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.