Prev: Query Analyzer - 'Failed to create DMO object'
Next: [241] Startup error: Unable to initialize error reporting system
From: Nik Marshall-Blank (delete fcom for my email address) on 26 Sep 2005 11:48
Or this

http://support.microsoft.com/default.aspx?scid=kb;en-us;165918
--
Nik Marshall-Blank MCSD/MCDBA

"Sabri AKIN" <SabriAKIN(a)discussions.microsoft.com> wrote in message
news:B8E724A2-122E-40B0-84FB-18393E25F9EB(a)microsoft.com...
>i done all your writes but dont work yet.database status change to suspect
> mode and dont permit to recover database


From: Nik Marshall-Blank (delete fcom for my email address) on 26 Sep 2005 11:53
Sorry that's 6.5

--
Nik Marshall-Blank MCSD/MCDBA

"Nik Marshall-Blank (delete fcom for my email address)"
<NikMB(a)fcomiNodefcom.afcomt> wrote in message
news:zLUZe.131890$in2.119840(a)fe04.news.easynews.com...
> Or this
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;165918
> --
> Nik Marshall-Blank MCSD/MCDBA
>
> "Sabri AKIN" <SabriAKIN(a)discussions.microsoft.com> wrote in message
> news:B8E724A2-122E-40B0-84FB-18393E25F9EB(a)microsoft.com...
>>i done all your writes but dont work yet.database status change to suspect
>> mode and dont permit to recover database
>
>


From: Tibor Karaszi on 26 Sep 2005 12:13
Open a case with Microsoft Support and see if they have any means of salvaging any data. Of,
assuming that you can access the database at all, export all data to a new healthy database (lot of
work, yes). Some thoughts also here: http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp



--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/


"Sabri AKIN" <SabriAKIN(a)discussions.microsoft.com> wrote in message
news:9A4C6270-8982-4718-B5E6-D81183DEC6DA(a)microsoft.com...
> our sqlserver has crashed and try to attach mdf file to server but sql server
> open this database in read only\suspect\offline\emergency mode.when we
> execute "select" query we take
> "torn page error".
> and i also execute
> "DBCC CheckDB
> ( 'dbname' ,REPAIR_ALLOW_DATA_LOSS )"
> and i take
> "Could not run BEGIN TRANSACTION in database 'dbname' because the database
> is in bypass recovery mode."
>
> when execute
> DBCC ALLOCDB ( 'dbname' )
> i take 16 allocation errors on this database
>
> i must take all data from this database how can i recover this database or
> take complete datas
>

First  |  Prev  | 
Pages: 1 2
Prev: Query Analyzer - 'Failed to create DMO object'
Next: [241] Startup error: Unable to initialize error reporting system