Hello, Everyone:
How to check if a database is corrupted, and how to fix the corruption? Thanks.
ZYTDBCC CHECKDB will give you some info on your data, DBCC CHECKCATALOG will report on system-related objects' problems of your db. I'm still using DBCC NEWALLOC from 6.5 world to actually fix any allocation-related issues. The last command reports AND fixes at the same time.
Showing posts with label corrupted. Show all posts
Showing posts with label corrupted. Show all posts
Tuesday, February 14, 2012
Database corrupted?
Hi all,
Had a disk problem here, and all apps connected to our database hung. Nothing was responding, rebooted, and mssqlserver hangs on startup.
If i move the mdf and ldf files of the database in question to another folder, mssqlserver starts up ok, with the db marked as suspect.
It would seem the the mdf and ldf are corrupted.
I am restoring a backup from yesterday, but this will take hours.
Any suggestions trying to recover it as it sits?
Thanks in advance for any ideas.I had the same problem just last week. The only fix was to restore from last good backup and bring the db forward as far as you can with transaction logs.|||Odds are near certain that you aren't hung, it is just doing a truly massive recovery operation when the server restarts. The only answer I know is to let it recover, then you can go merrily on your way with your data intact.
-PatP|||Let it recover, it that complete, and run a dbcc checkdb to verify.|||Odds are near certain that you aren't hung, it is just doing a truly massive recovery operation when the server restarts. The only answer I know is to let it recover, then you can go merrily on your way with your data intact.
-PatP
The restore completed....now its time for the post-mortem.
The problem I was having was that I could not access the database using Query Analyzer, any application software, or Enterprise Manager. Any attempt to connect would result in a time-out, or just hang when trying to connect.
If the DB is not responding, how can one determine if a recovery operation is in progress?|||I use sp_who. Check for a low numbered (usually 10) spid doing a recovery in the database in question.
-PatP|||In answer to your next question "How do I run sp_who when I can't connect through Query Analyzer?", the answer is to try the OSQL command line utility, which sometimes works when all others fail.|||Good anticipation blindman :)
Thanks for the suggestions. I will file this information away for future reference.
Had a disk problem here, and all apps connected to our database hung. Nothing was responding, rebooted, and mssqlserver hangs on startup.
If i move the mdf and ldf files of the database in question to another folder, mssqlserver starts up ok, with the db marked as suspect.
It would seem the the mdf and ldf are corrupted.
I am restoring a backup from yesterday, but this will take hours.
Any suggestions trying to recover it as it sits?
Thanks in advance for any ideas.I had the same problem just last week. The only fix was to restore from last good backup and bring the db forward as far as you can with transaction logs.|||Odds are near certain that you aren't hung, it is just doing a truly massive recovery operation when the server restarts. The only answer I know is to let it recover, then you can go merrily on your way with your data intact.
-PatP|||Let it recover, it that complete, and run a dbcc checkdb to verify.|||Odds are near certain that you aren't hung, it is just doing a truly massive recovery operation when the server restarts. The only answer I know is to let it recover, then you can go merrily on your way with your data intact.
-PatP
The restore completed....now its time for the post-mortem.
The problem I was having was that I could not access the database using Query Analyzer, any application software, or Enterprise Manager. Any attempt to connect would result in a time-out, or just hang when trying to connect.
If the DB is not responding, how can one determine if a recovery operation is in progress?|||I use sp_who. Check for a low numbered (usually 10) spid doing a recovery in the database in question.
-PatP|||In answer to your next question "How do I run sp_who when I can't connect through Query Analyzer?", the answer is to try the OSQL command line utility, which sometimes works when all others fail.|||Good anticipation blindman :)
Thanks for the suggestions. I will file this information away for future reference.
Database Corrupted, Need help recovering data from LDF file
A friend of mine called and said that his database was suspect and he detached it and was unable to attach it. The SQL Server Version is 2000 with the latest service packs installed. When I checked it the database (MDF) size was 1MB and the LDF size was 3.8 GB. I was not able to attach the two together and I was not able to attach the database using sp_attach_single_file_db. I did find an old backup of his database and attached that so he can work off of it but it is 1 yr old and he needs recent data. Since the MDF seemed to be blank we cant do much with that, but there seems to be data in the LDF. Is it possible to extract any data from the LDF file?
SunnyThe log file contains low level physical changes that are almost impossible to correlate with user objects without the metadata in the data files.
Database Corrupted, Need help recovering data from LDF file
A friend of mine called and said that his database was suspect and he detached it and was unable to attach it. The SQL Server Version is 2000 with the latest service packs installed. When I checked it the database (MDF) size was 1MB and the LDF size was 3.8 GB. I was not able to attach the two together and I was not able to attach the database using sp_attach_single_file_db. I did find an old backup of his database and attached that so he can work off of it but it is 1 yr old and he needs recent data. Since the MDF seemed to be blank we cant do much with that, but there seems to be data in the LDF. Is it possible to extract any data from the LDF file?
SunnyThe log file contains low level physical changes that are almost impossible to correlate with user objects without the metadata in the data files.
Database corrupted since windows reboot
Hi,
My librarian has a problem with is computer. He uses it to store all of
his client's asks, his inventory, etc... on a SQL server's database,
with the help of a third part program, and he never restart his computer.
He few weeks ago, some problems on our city (in France), make his
computer turn off, then restart. And while windows was restarting, it
install to him the latest version of some software - but he didn't
notice which one. And when he turns on the program, the sql server's
database where corrupted, and he wasn't able to use it again:
unfortunately, the program was using it when the computer turn off.
Nonetheless, he didn't made any daily save, so he lost all the
information about his business since a month...
He would like to know if there a way to repair the database, in order to
use it again, instead of restart from 0. He write to the program's
maker, but he wasn't able to restore the data, and a google search
didn't help: none of the answer where about this problem... So is there
any special keywords that I could use, or a known way to repair the base?
Thanks a lot for answer,
Aramiil
Hi,
Could you please answer to below queries:-
1. Are you able to start your SQL Server Service?
2. Did you gone thru the SQL Server Error logs and Event viewer?
3. What is the exact error you ere getting or you have pointed out?
4. How did you come to the conclusion that your database is crached?
Thanks
Hari
SQL Server MVP
"Yann PIQUET" <aramiil@.neobelari.com> wrote in message
news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
> Hi,
> My librarian has a problem with is computer. He uses it to store all of
> his client's asks, his inventory, etc... on a SQL server's database, with
> the help of a third part program, and he never restart his computer.
> He few weeks ago, some problems on our city (in France), make his computer
> turn off, then restart. And while windows was restarting, it install to
> him the latest version of some software - but he didn't notice which one.
> And when he turns on the program, the sql server's database where
> corrupted, and he wasn't able to use it again: unfortunately, the program
> was using it when the computer turn off. Nonetheless, he didn't made any
> daily save, so he lost all the information about his business since a
> month...
> He would like to know if there a way to repair the database, in order to
> use it again, instead of restart from 0. He write to the program's maker,
> but he wasn't able to restore the data, and a google search didn't help:
> none of the answer where about this problem... So is there any special
> keywords that I could use, or a known way to repair the base?
> Thanks a lot for answer,
> Aramiil
|||Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1=2E Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2=2E Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3=2E The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder =E0 la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4=2E idem
Thanks a lot for answer.
Hari Prasad a =E9crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
th[vbcol=seagreen]
ter[vbcol=seagreen]
e=2E[vbcol=seagreen]
am[vbcol=seagreen]
r,[vbcol=seagreen]
|||Hi,
The error logs attached are in French.. Sorry , I am not able to understand.
Thanks
Hari
<apislibrairie@.wanadoo.fr> wrote in message
news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1. Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3. The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4. idem
Thanks a lot for answer.
Hari Prasad a crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
|||Hi,
Sorry, I've forgot to translate them... Here are two of them translated
in english (I hope I didn't do too many errors in translation :-/), I'll
post a link to the others one when I'll have finish them.
http://www.neobelari.com/SQLAGENT_eng_part1.zip
Thanks,
Aramiil
Hari Prasad a crit :
> Hi,
> The error logs attached are in French.. Sorry , I am not able to understand.
> Thanks
> Hari
> <apislibrairie@.wanadoo.fr> wrote in message
> news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
> Hi,
> Well, I don't really know about SQL server, so I just can answer a few
> of your questions:
> 1. Yes, I'm able to start my SQL Server Service, and to use an older
> save of the databse, aged of near a month.
> 2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
> 3. The program (called Octave) display a message with this: "Base
> corrompue, impossible d'acceder la base". I'm not used to work with
> SQL server, so I don't have any other informations by the sql server
> 4. idem
> Thanks a lot for answer.
> Hari Prasad a crit :
>
>
My librarian has a problem with is computer. He uses it to store all of
his client's asks, his inventory, etc... on a SQL server's database,
with the help of a third part program, and he never restart his computer.
He few weeks ago, some problems on our city (in France), make his
computer turn off, then restart. And while windows was restarting, it
install to him the latest version of some software - but he didn't
notice which one. And when he turns on the program, the sql server's
database where corrupted, and he wasn't able to use it again:
unfortunately, the program was using it when the computer turn off.
Nonetheless, he didn't made any daily save, so he lost all the
information about his business since a month...
He would like to know if there a way to repair the database, in order to
use it again, instead of restart from 0. He write to the program's
maker, but he wasn't able to restore the data, and a google search
didn't help: none of the answer where about this problem... So is there
any special keywords that I could use, or a known way to repair the base?
Thanks a lot for answer,
Aramiil
Hi,
Could you please answer to below queries:-
1. Are you able to start your SQL Server Service?
2. Did you gone thru the SQL Server Error logs and Event viewer?
3. What is the exact error you ere getting or you have pointed out?
4. How did you come to the conclusion that your database is crached?
Thanks
Hari
SQL Server MVP
"Yann PIQUET" <aramiil@.neobelari.com> wrote in message
news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
> Hi,
> My librarian has a problem with is computer. He uses it to store all of
> his client's asks, his inventory, etc... on a SQL server's database, with
> the help of a third part program, and he never restart his computer.
> He few weeks ago, some problems on our city (in France), make his computer
> turn off, then restart. And while windows was restarting, it install to
> him the latest version of some software - but he didn't notice which one.
> And when he turns on the program, the sql server's database where
> corrupted, and he wasn't able to use it again: unfortunately, the program
> was using it when the computer turn off. Nonetheless, he didn't made any
> daily save, so he lost all the information about his business since a
> month...
> He would like to know if there a way to repair the database, in order to
> use it again, instead of restart from 0. He write to the program's maker,
> but he wasn't able to restore the data, and a google search didn't help:
> none of the answer where about this problem... So is there any special
> keywords that I could use, or a known way to repair the base?
> Thanks a lot for answer,
> Aramiil
|||Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1=2E Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2=2E Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3=2E The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder =E0 la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4=2E idem
Thanks a lot for answer.
Hari Prasad a =E9crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
th[vbcol=seagreen]
ter[vbcol=seagreen]
e=2E[vbcol=seagreen]
am[vbcol=seagreen]
r,[vbcol=seagreen]
|||Hi,
The error logs attached are in French.. Sorry , I am not able to understand.
Thanks
Hari
<apislibrairie@.wanadoo.fr> wrote in message
news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1. Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3. The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4. idem
Thanks a lot for answer.
Hari Prasad a crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
|||Hi,
Sorry, I've forgot to translate them... Here are two of them translated
in english (I hope I didn't do too many errors in translation :-/), I'll
post a link to the others one when I'll have finish them.
http://www.neobelari.com/SQLAGENT_eng_part1.zip
Thanks,
Aramiil
Hari Prasad a crit :
> Hi,
> The error logs attached are in French.. Sorry , I am not able to understand.
> Thanks
> Hari
> <apislibrairie@.wanadoo.fr> wrote in message
> news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
> Hi,
> Well, I don't really know about SQL server, so I just can answer a few
> of your questions:
> 1. Yes, I'm able to start my SQL Server Service, and to use an older
> save of the databse, aged of near a month.
> 2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
> 3. The program (called Octave) display a message with this: "Base
> corrompue, impossible d'acceder la base". I'm not used to work with
> SQL server, so I don't have any other informations by the sql server
> 4. idem
> Thanks a lot for answer.
> Hari Prasad a crit :
>
>
Database corrupted
Hello there
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>>
>|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>> Whell Uri
>> It worst then i thought.
>> there are more then 5000 text files with SQLDumpxxxx.text
>> And i'm getting many messages that many data has gone lost.
>> where can i start investigate it?
>>
>> there is huge list of files on the LOG
>> and there are
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact
>> your system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>>
>>
>|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:
>did you got the mail i send to you?
>> Open the ERROR.LOG and lookup for specific date. It should be at the
>> bottom of the file
>[quoted text clipped - 32 lines]
>>> Now i'm restoring my old db. what can cause this error and how can i
>>> prevent from having this error?
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>>
>|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>> Whell Uri
>> It worst then i thought.
>> there are more then 5000 text files with SQLDumpxxxx.text
>> And i'm getting many messages that many data has gone lost.
>> where can i start investigate it?
>>
>> there is huge list of files on the LOG
>> and there are
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact
>> your system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>>
>>
>|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:
>did you got the mail i send to you?
>> Open the ERROR.LOG and lookup for specific date. It should be at the
>> bottom of the file
>[quoted text clipped - 32 lines]
>>> Now i'm restoring my old db. what can cause this error and how can i
>>> prevent from having this error?
Database corrupted
Hello there
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?
This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>
|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>
|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>
|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>
|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>
|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>
|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:[vbcol=seagreen]
>did you got the mail i send to you?
>[quoted text clipped - 32 lines]
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?
This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>
|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>
|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>
|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>
|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>
|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>
|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:[vbcol=seagreen]
>did you got the mail i send to you?
>[quoted text clipped - 32 lines]
Database corrupted
Hello there
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:[vbcol=seagreen]
>did you got the mail i send to you?
>
>[quoted text clipped - 32 lines]
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:[vbcol=seagreen]
>did you got the mail i send to you?
>
>[quoted text clipped - 32 lines]
database corrupt
What can I do if I failed to attach a database by EM?
If the database is corrupted, any method to recover the
database?
hi Tony,
"Tony" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:06b901c4a073$d7dd8a40$a401280a@.phx.gbl
> What can I do if I failed to attach a database by EM?
> If the database is corrupted, any method to recover the
> database?
if you have a clean backup, this usually is the best solution to go but, if
the database can be saved, perhaps the advices by Jasper as per
http://tinyurl.com/3pxhv can be helpfull
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
What is the error you are getting while attaching?
Best option after a corrruption will be restoring from a good backup. If you
do not have the backup try below:-
1. Execute DBCC CHECKDB('db_name','REPAIR_REBUILD') , this will corrupt
minor issues.
If you do not have any options try with Jaspers suggestion
http://www.google.it/groups?q=+%22sp...ftngp09&rnum=1
Thanks
Hari
MCDBA
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2re0b2F18k52cU1@.uni-berlin.de...
> hi Tony,
> "Tony" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
> news:06b901c4a073$d7dd8a40$a401280a@.phx.gbl
> if you have a clean backup, this usually is the best solution to go but,
> if
> the database can be saved, perhaps the advices by Jasper as per
> http://tinyurl.com/3pxhv can be helpfull
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
If the database is corrupted, any method to recover the
database?
hi Tony,
"Tony" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:06b901c4a073$d7dd8a40$a401280a@.phx.gbl
> What can I do if I failed to attach a database by EM?
> If the database is corrupted, any method to recover the
> database?
if you have a clean backup, this usually is the best solution to go but, if
the database can be saved, perhaps the advices by Jasper as per
http://tinyurl.com/3pxhv can be helpfull
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
What is the error you are getting while attaching?
Best option after a corrruption will be restoring from a good backup. If you
do not have the backup try below:-
1. Execute DBCC CHECKDB('db_name','REPAIR_REBUILD') , this will corrupt
minor issues.
If you do not have any options try with Jaspers suggestion
http://www.google.it/groups?q=+%22sp...ftngp09&rnum=1
Thanks
Hari
MCDBA
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2re0b2F18k52cU1@.uni-berlin.de...
> hi Tony,
> "Tony" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
> news:06b901c4a073$d7dd8a40$a401280a@.phx.gbl
> if you have a clean backup, this usually is the best solution to go but,
> if
> the database can be saved, perhaps the advices by Jasper as per
> http://tinyurl.com/3pxhv can be helpfull
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Subscribe to:
Posts (Atom)