Re: DATABSE IS SUSPECT BECAUSE OF MISSING FILES

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 13:57:00 -0400

Uhhh, but did you actually read it? It details exactly what to do in this
situation including resetting the suspect status. There are no supported
methods that will work 100% of the time when you delete the log. Your best
bet is to restore from know good backups. If that's not an option you can
try sp_attach_single_file_db and this method. You can also call MS PSS and
let them walk you trough it.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS 

-- 
Andrew J. Kelly  SQL MVP
"James" <jcolbert30@yahoo.com> wrote in message
news:2496001c45f89$77adbe90$a501280a@phx.gbl...
> Sorry but no...
>
> The exact problem that I am having is that files are
> missing and your reply does not address how to recover
> from this problem. In other words how do I replace the
> missing files that SQL needs in order to remove the DB
> from the suspect mode?
>
> Any further suggestions would be appreciated, thanks.
>
> James

Relevant Pages

  • Re: Tiger Stock
    ... a lot of money selling applications based on their own platform. ... larger players support more interfaces, ... Coming back to a point in the last paragraph: Lack of support for SQL ... So if we take that off the table and compare companies, ...
    (comp.databases.pick)
  • RE: SQL Set to System Account - Sharepoint Question
    ... Administration", not System Account) account. ... after the installation there isn't normally any reason to ... SQL, don't use an instance being used for anything else. ... the App Support people why SA is required. ...
    (microsoft.public.windows.server.sbs)
  • Re: OT: IRAN
    ... government provides evidence on the contrary. ... We may not be happy with the results in Iran, we have every right to suspect corruption, and even to voice our concerns over that corruption. ... And merely stating - as I have - that you suspect that there is foul-play while also admitting that - so far - no evidence exists to prove that suspicion is hardly a support for the repression. ...
    (rec.music.beatles)
  • Re: SQL Mobile and Datasets Problem
    ... About the database question, in the sql server 2005 table that is used to replicate with the mobile database, i put the flag rowguid to false in the uniqueidentifier primary key. ... Can i use the sql server 2005 tables for RDA replication without any identity columns defined? ... If you'd like to know more details about this, I recommend that you open a Support incident with Microsoft Customer Support Services so that a dedicated Support Professional can work with you in a more timely and efficient manner. ...
    (microsoft.public.sqlserver.replication)
  • Re: sqlstring -- a library to build a SELECT statement
    ... > short-circuiting behaviors regarding them (the resultant bytecode will ... How to best add further sql function support? ... > database does not support a given function (or operator, ... > case-insensitive in MS SQL Server but case-sensitive in PostgreSQL). ...
    (comp.lang.python)
Loading