Re: Newbie Help!

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 12/12/04 

Date: Sat, 11 Dec 2004 23:27:37 -0500

I agree with Andrew. Call the experts. They can walk you throught the
steps most likely to get your data back. Right after that phone call, find
yourself a temporary IT guy from a reputable consulting company. You will
probably have to pay extra for the emergency coverage, but if your business
depends on your systems, you really don't have a choice. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:eTcXXn%233EHA.2592@TK2MSFTNGP09.phx.gbl...
> Your best bet if you want it fixed ASAP and with the least risk of data
loss
> is to contact MS PSS so they can work directly with you to see what can be
> done. Is your data worth about $225.00?  I suspect it is and that will be
a
> small price to pay to get it fixed properly.
>
>
> 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
>
>
> "Paul Davies" <bob@notachance.com> wrote in message
> news:_9Kud.6383$Cp4.2422@fe1.news.blueyonder.co.uk...
> >I work for a company who have just lost the IT Manager, and we are in the
> >process of appointing another, I am a amature person (normally in sales,
> >don't hate me). However, we are using Sharepoint POrtal server with a SQL
> >2000 server for the databases.
> >
> > There is the companyC1_SITE database which is now showing as suspect
after
> > a server restart, and I notice the LDF is showing 0kb size.
> >
> > The msdb.mdf is also showing as suspect.
> >
> > The error log says that the SITE database was not detached cleanly.
> >
> > I have a backup from the beginning of October, but nothing after that
> > seems to be valid. So I now must rely on whether or not it will be
> > possible to recover the corrupt site MDF?
> >
> > The MDF's are on a RAID array with 270GB free space so the databases did
> > not become suspect due to space running out.
> >
> > Any pointers would be very much appreciated.
> >
> > P.
> >
>
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)