Assertion corruption when importing data  ?


I work on SQL server 2000. I have decided to transfer large volume of data in to my SQL Server Tables from any other database management system. I don\'t want to use command prompt for this so instead of using BCP (Bulk Copy Program) utility for this purpose I used ‘Bulk Insert\' T-SQL” command. When I executed “Bulk Insert” T-SQL” command to import data then my SQL MDF files become inaccessible and I got some error message. Then I use BCP command line utility for this purpose but failed. And got same error message –

“Server: Msg 823, Level 24, State 2, Procedure gfspTMAppendText, Line 20 I/O error (bad page ID) detected during read at offset 0x0000000024e000 in file \'C:\\Program Files (x86)\\Microsoft SQL Server\\MSSQL\\data\\REPRO.mdf\'”

And in the server error log I got the error message like—

“DateTime spid53 SQL Server Assertion: File: <SpcAlloc.cpp>, line=466 Failed Assertion = \'0\'.”

I run DBCC Checkdb command to check corruption has occurred or not. When I execute this then I receive some error message like-

“ Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:105). The PageId in the page header = (0:0).”

Now, what I do to come up from the database corruption. I need my data back, seriously. Pl. suggest me any way to repair and recover my SQL Server database.


            

 


Know the Answer? Share it...

Assertion corruption when importing data  ?

Name  
Email ID  
Your Answers, View or Suggestion  
     
   

 


Related Question

  Slow performance of SQL server 2005 ?

  State a way with which I can get fixed my entire corrupt SQL Database? ?

  Suggest a Recovery for repairing the Read only Database in SQL 2000 ?

  Is Mdf Repair Software best for SQL Server files of 2005? ?

  Suggest for a Database Repair Tool for SQL Server 2005 ?

  Suggest a process for fixing a table in Ms Sql? ?

  How can you recover the Index Fragmentation in the SQL Database? ?

  State a recovery for the corrupt index Database of Ms Sql. ?

  Make a recovery for MDF files which has got deleted unexpectedly. ?

  You are not allowed to access the database from this machine, please verify your access id or contact database administrator”. What this message indicates? ?

  Incorrect Key File for table”….Try to repair it.” What this message specifies? ?

  Database got corrupt by SQL Injection Attacks”. How to Repair ?

  I am middle in the problem. Facing error in I/O operation on sql. Give solution for best command to repair mssql database ?

  The error is generated in database. How to check db space mssql ?

  SQL database giving an error on 2000 sql repair tool is working slowly. What to do ?

  Getting the errorin SQL 2005: # table corrupted # buffer is too small, unavailability of free disk space. ?

  How to run dbcc on mdf file on MS SQL server 2005. Describe some solutions ?

  The SQL server log file giving error. How can be repairing ms sql log files ?

  my SQL table database does not return any value. How to restore table from mdf file ?

  The MS SQL has generated an error while restoring the database. How to recover mssql database ?

  SQL is giving an encrypted error. How to fix mdf file of sql server 2005 error ?

  Table error: Object ID 0, index ID 0, page ID (1:105). The PageId in the page header = (0:0) ?

  Bug in libmysql.dll ?

  Destroyed key cache still usable ?

  Problem with intensive locking (deadlocks?) during execution of system_1_test ?