Hey but thanks though, I forgot to add that to my last post. I appreciate
your help, and saved it just incase I have this problem on any non system
databases
J.
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.
-----Original Message-----
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 12:03 PM
To: CF-Server
Subject: RE: SQL Server
Yikes. A system database, huh? I don't know what to tell you besides
recommending that you check out some news group postings
(http://groups.google.com), the Microsoft Knowledgebase
(http://search.support.microsoft.com/kb), and sites like NT FAQ
(http://www.ntfaq.com).
I wish I could be more help, but, fortunately, I've never had to rescue a
suspect system database. There should be a way, though it will probably
include hacking your way through system tables. A "suspect" status usually
only means that their is some inconsistency between the data and the log
files and is usually caused by an error writing to the hard drive such as a
bad sector or inopportune shutdown. Have you figured out what caused the
problem? Check the SQL error logs to determine this.
Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057
-----Original Message-----
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 12:32 PM
To: CF-Server
Subject: RE: SQL Server
I hear ya on that. I was trying to reset and recover all day yesterday to no
avail.
Your method works up until the dropping Db thing. The Suspect DB is a system
DB. Any thoughts on that one?? :-)
Thanks though I'm closer, I can open the DB and get data out and such
J.
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.
-----Original Message-----
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 7:07 AM
To: CF-Server
Subject: RE: SQL Server
Well, the first thing to try is to reset the status on the database. This
document talks about how to do this:
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14047
That said, this technique has never worked for me. What has worked, is the
following procedure:
1) Creating a new, temporary database
2) Place the suspect database into "emergency mode" (see the above article)
3) Transfer the data from the suspect database to the temporary database
(you should be able to transfer with DTS)
4) Check the data in the temporary database to make sure the transfer was
successful.
5) Drop the suspect database
6) Create a new database with the same name as the old suspect database
7) Transfer the data from the temporary database to the new database.
8) Check the data in the new database to make sure the transfer was
successful.
9) Drop the temporary database
10) Re-setup any permissions, scheduled tasks, etc., including a scheduled
task that backs up your database regularly. :)
Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057
-----Original Message-----
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 6:00 PM
To: CF-Server
Subject: OT: SQL Server
I know this isn't CF Server, but to stretch it, technically my SQL box is my
CF box (Budgetary constraints, you know, LOL)
At any rate today out of the blue my MSDB database get's tagged suspect. I'm
no SQL DBA so I fussed with what I could find in Books online and didn't get
very far, kept trying to re-set up the data and log files and the stored
proc kept saying the LSN was wrong.
I'd restore, but in my complete lunacy didn't include msdb in my backup set.
Anybody been here done that?
It's SQL 2k on a Win2k AS box.
Much thanks in advance.
J.
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
www.red-omega.com
"Losing - If at first you don't succeed, failure may be your style."
~despair.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
