Downloads Becoming Corrupt While Use FTP Task
Aug 7, 2006
I have a Package that downloads apprx 15 data archives from an FTP site using FTP Tasks.
My problem is that the data contained within these archives (.Z) are becoming corrupt after download/extracting. I have isolated the problem to the FTP File Task by manually downloading the archives myself from IE's built-in FTP client and disabling the downloads in the Control Flow. The Control Flow will then execute the extracting script and continue without any problems.
If I run the Package with the FTP Tasks enabled it will get to a random spot in the validation (I haven't been able to see any consistency with where it errors) of the flat files and error with either a truncation error or a (don't remember exactly what it was) error that talks about an unexpected end in the file. I believe this is because the data has become corrupt and has started skipping/excluding columns. I have opened the flat file and examined it, and sure enough, the data at the end seems to just end.
I have tried setting the FTP Connection to Use Passive Mode in the config file - doesn't work.
So, my question is: Has anyone encountered similar problems? If so, what did you do to fix the problem? I'd really like to use the FTP Task rather than reinventing it with a custom script.
View 1 Replies
ADVERTISEMENT
Jul 24, 2007
When attempting to use the FTP task to download a file from a Mainframe system the task fails stating the filename as invalid because it doesn't begin with a "/".
Adding the slash to the front of the file name causes the mainframe to be unable to locate the file.
Commandline version of FTP.exe mimicks this behavior by working perfectly when the filename has no slash, and being unable to find the file when the slash is present.
Why does microsoft force a filename to start with a "/" and is there a way to make SSIS skip the validation phase for the FTP task?
View 7 Replies
View Related
Nov 6, 2006
I went to install SQL 2005 and did not have sufficient memory, I registered prior to the download, will i still be able to down load it after nov 7 and after i buy more memory ( there is no iso file to save )
Thanks
Ray
View 1 Replies
View Related
Sep 11, 2007
Does anybody know where I can download the samples ? What I mean is not the Northwind or pubs database but samples that are usually installed in "C:Program FilesMicrosoft SQL Server90Samples" directory; I am missing them.
Thanks
View 2 Replies
View Related
Sep 14, 2006
Dear all
Where can I download Sql Server Books Online for any versions of 6.5 or 6.0 or 4.
thanks
View 1 Replies
View Related
Dec 16, 2005
Hi, Just a quick note for all that the SSIS team has started to post fresh content for download.
We will be adding some links to various pages so you can easily see things when looking at the the SSIS portal on MSDN http://msdn.microsoft.com/SQL/bi/integration/default.aspx
For now if you search for "ssis" on the microsoft downloads site you will find the current content. Sample Logging reports, jump start training, Meta Data info, and sample components. More coming over the next few weeks...
http://www.microsoft.com/downloads/search.aspx?displaylang=en
Thank you and I hope everyone enjoys winding down 2005, or blowing it out, depending on your likes :)
SSIS team
View 1 Replies
View Related
Sep 22, 2007
1. The download links shown below for the Starter Kits found at this URL do not work:
http://msdn2.microsoft.com/en-us/express/aa718396.aspx
Teacher Starter Kit
VB http://msdn.microsoft.com/vstudio/eula.aspx?id=4d31bb50-22da-411f-b747-a7b2288fc720
C# http://msdn.microsoft.com/vstudio/eula.aspx?id=06b20449-cbba-4f2f-ab8c-b99c1266cc7e
Collection Manager Starter Kit
http://msdn.microsoft.com/vstudio/eula.aspx?id=98c8074d-d28e-49e1-be44-94f0114f372a
Club Web Site EventCalendar control source code
http://www.asp.net/starterkits/downloads/eventcalendar.zip
2. None of the download links shown below for the Sample Applications found at this URL work:
http://msdn2.microsoft.com/en-us/express/bb403187.aspx
Internet Explorer Favorites Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=3bdccf1b-88c6-45a6-9dcf-7499ad664dab
Skills Manager Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=09305c92-890f-4dc7-a20d-f58b611d23c7
Survey Manager Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=98171070-e0f6-4fcd-948e-9c5af497ab4f
Help Desk Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=009e3b2d-98b1-46dc-8476-676a2519eafa
Reports for Web Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=79610b4f-fc7e-4ca8-9ae2-8ca8a5a6de0d
Reports for Windows Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=9c9a8d75-58b1-4be7-91be-50fefbe5d28c
View 2 Replies
View Related
Jun 21, 2007
OK. I give up and need help. Hopefully it's something minor ...
I have a dataflow which returns email addresses to a recordset.
I pass this recordset into a ForEachLoop configuring the enumerator as (Foreach ADO Enumerator). I also map the email address as a variable with index 0.
I then have a Execute SQL task which receives this email address as a varchar variable (parameter 0) which I then use in my SQL command to limit the rows returned. I have commented out the where clause and returned all rows regardless of email address to try to troubleshoot this problem. In either event, I then use a resultset to store the query result of type object and result name 0.
I then pass this resultset into a script variable to start parsing the sql rows returned as type object. ( I assume this is the correct way to do this from other prior posts ...).
The script appears to throw an exception at the following line. I assume it's because I'm either not passing in the values properly or the query doesn't return anything. However, I am certain the query works as it executes just fine at the command prompt.
Try
ds = CType(Dts.Variables("VP_EMAIL_RESULTS_RS").Value, DataSet)
My intent is to email the query results to each email address with the following type of data by passing the parsed data from the script to a send mail task. Email works fine and sends out messages but the content is empty. I pass the parsed data as string values to the messagesource and define the messagesourcetype as a variable in the mail task.
part number leadtime
x 5
y 9
....
Does anyone have any idea what I might be doing wrong?
thanks
John
View 5 Replies
View Related
Oct 12, 2001
I found this script some where on internet..i am not sure what it does and how to i solve the problem because my friend has already run the script and i donno how to get back to the original configuration.
/* this script works on a database that is a copy of pubs. I created this database easily with DTS
This only works on SQL Server 7 databases
*/
/* NOTE: This script will truly corrupt a database. It should not be run on ANY real
database. It is only for simulating corruption for training purposes.
*/
sp_configure allow, 1
go
reconfigure with override
go
update sysindexes set FirstIAM = 1234
where id = OBJECT_ID('roysched')
go
sp_configure allow, 0
go
reconfigure with override
go
How to sovlve the issue after the corrupt is done...how do i modify the info back to original..
Are there any other process or script that i can simulate to corrupt the databse and solutions pertaining to the same..i would like to experiment and then see how it goes and how quickly i can solve...
Thanks,
Jeff
View 2 Replies
View Related
May 27, 2003
The ldf file of a db was deleted by mistake. This was done whilst the SQL Server Service was still running. The db was not detached cleanly. I ran sp_detach_db on the db and tried re-attaching but got the error message:
"Database [dbname] cannot be opened because some of the files could not be activated".
Subsequently I have tried creating a new db called the same as the old one. Stopping the MSSQL service, copying over the mdf and re-starting the service. The db still comes up as suspect and the error log shows "Device activation error. The physical file name 'D:LogsETERBK_Log.LDF' may be incorrect". I have tried copying over the new ldf to the correct location but the same message appears.
I am not interested in getting the data back but would like to get back the stored procedures. Can anyone help this is urgernt?
View 8 Replies
View Related
Jul 6, 2006
Have a corrupt SQL database that I am unable to repair using any of the repair options with DBCC CHECKDB. Below is the output from the repair_allow_data_loss option.
I can't seem to figure out how to go about fixing this. Any takers?!
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:24264) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.
Server: Msg 8921, Level 16, State 1, Line 1
CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:24264). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:24264). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:24264). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:24264). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:24264). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:24264). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 7 pages from (1:24264) to (1:32351). See other errors for cause.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:32352). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:32352). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:32352). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 7 pages from (1:32352) to (1:40439). See other errors for cause.
DBCC results for '8602955'.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 8 allocation errors and 3 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 1395 rows in 27 pages for object 'sysobjects'.
CHECKDB found 8 allocation errors and 3 consistency errors in database '8602955'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
View 20 Replies
View Related
Aug 24, 2006
I have a table that I can't read any data.
It hangs up when I try to drop it as well.
So, what are my options here? Secondly, what has caused this?
View 5 Replies
View Related
Feb 7, 2002
I had installed a third-party software on my server and that corrupted my Master DB. Over the weekend when we bought SQL server down, we could not bring it back up. I had to re-install SQL server and then restore all my databases from the backup. Is there a better way of doing this???
Curiously
Someone who calls himself a DBA
View 4 Replies
View Related
Jul 23, 2002
Hi everybody,
I have a strange problem with one of the jobs created through a maintenace plan. The idea is that every 2 hours a transaction log backup is created and backups older than 2 days should be removed. This worked for several months without a problem, but suddenly today the job reports failed as status.
I looked into jobhistory but all I got is the following message:
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Strange enough reports the sqllog that the t-log has been backed up succesfully. The files are on disk and I can restore them without a problem.
Any ideas what is going on ???
Tia Markus
View 1 Replies
View Related
Mar 28, 2001
Hi All,
I am working in a test environment where I need to corrupt a database for test purpose/R&D. After corrupting the database, I ran the DBCC CHECKDB (pubs, repair_fast) and then DBCC CHECKDB (pubs, repair_rebuild) commands. But DBCC is not fixing the corrupt database.
My question is why DBCC is not fixing the corrupted Database? Is that a limitation of DBCC or is there any other way/command or tool to fix the corrupted database other then restoring from the previously backed up file.
The following are the steps that I followed to corrupt the database:
I used the following script (available in the script section of www.swynk.com) to corrupt the pubs database.
sp_configure allow, 1
go
reconfigure with override
go
update sysindexes set FirstIAM = 1234
where id = OBJECT_ID('roysched')
go
sp_configure allow, 0
go
reconfigure with override
go
Then I did a select * from roysched. I got the error:
Server: Msg 5180, Level 22, State 1, Line 1
Could not open FCB for invalid file ID 53764 in database 'pubs'. Table or database may be corrupted.
The pubs database got corrupted. Now, I want to fix this error. So I set the pubs database to single user mode and ran the DBCC command :
DBCC CHECKDB (pubs, repair_fast) that doesn't help so I ran the DBCC CHECKDB (pubs, repair_rebuild) command.
I got big DBCC output. I doesn't seems to fix the pubs database. When I did a select * from roysched again it gave the same corruption error.
I would appreciate any help in this issue.
Thanks
Sri
View 10 Replies
View Related
May 30, 2001
Hi,
One of my tables got corrupt and it is not possible to bring down the Database into Single user mode to run the dbcc to repair it. Is there any other way that I could correct.
Thanks
Cynthia
Msg 8978, Sev 16: Table Corrupt: Object ID 901630305, index ID 8. Page (5:572498) is missing a reference from previous page (8:98777). Possible chain linkage problem. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 901630305, index ID 8: Page (8:98777) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8976, Sev 16: Table Corrupt: Object ID 901630305, index ID 8. Page (8:98777) not allocated or corrupt. Parent (5:335525) and previous (5:572497) refer to it. [SQLSTATE 42000]
Msg 8944, Sev 16: Table Corrupt: Object ID 901630305, index ID 8, page (8:98777), row 38. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 525 and 26. [SQLSTATE 42000]
View 3 Replies
View Related
May 23, 2000
What is the best approach to repairing a corrupt table? I received the following error from last night's maintenance. (SQL 6.5)
Thanks, Kevin
[2] Check Data Allocation...
WARNING: Database AHSDATA is currently being used by 1 user(s).
This may cause spurious problems to be reported.
The following errors were found:
Table Corrupt: object id does not match between extent in allocation page and Sysindexes; check the following extent: alloc pg#=247552 extent#=247720 object id on extent=-1175060352 (object name = -1175060352) object id in Sysindexes=1329491865 (object name = PS_AHS_RETIRE_2000)
Table Corrupt: Index id on extent should be 0; check the following page and ids: alloc page=247552 extent=247720 index id on extent=200
Table Corrupt: Extent structures are linked incorrectly; check the following extent: alloc pg#=247552 extent#=247720 previous extent# on this extent=-1 previous extent should be=247712
Table Corrupt: Object id wrong; tables: alloc page 247552 extent id=247720 l page#=247720 objid in ext=-1175060352 (name = -1175060352) objid in page=1329491865 (name = PS_AHS_RETIRE_2000)objid in sysindexes=1329491865 (name = PS_AHS_RETIRE_2000)
** Execution Time: 0 hrs, 10 mins, 50 secs **
[3] Update Statistics...
[Microsoft SQL-DMO] Error 605: [SQL Server] Attempt to fetch logical page 247792 in database 'AHSDATA' belongs to object 'PSPNLDEFN', not to object 'PS_AHS_RETIRE_2000'.
[Microsoft SQL-DMO] Error 10025: [DB-Library] Possible network error: Write to SQL Server Failed.
** Execution Time: 0 hrs, 5 mins, 11 secs **
View 4 Replies
View Related
Apr 6, 2000
Hi,
I am receiving an Msg 2540 on a database when I perform the DBCCs. It looks like the indexes on this one table got corrupt. I know this because when I perform the DBCCs with the noindex option then I do not get any errors. I tried to drop and recreate the indexes (two indexes - one clustered and one unique) but to no avail. The dbccs continued to produce the error.
If someone has any ideas please respond. This is a prodn problem and so any input would be greatly appreciated.
Thanks again
Kiran
View 1 Replies
View Related
Sep 14, 1999
I have been having problems with the SQL 7 server when temporary tables are being created, so I ran a DBCC checkdb against tempdb,
and this is what came back. When I try to run the dbcc with repair_allow_data_loss it says the database must be in single user mode.
This option is not allowed in tempdb. So now what? Does any one have any suggestions?
Server: Msg 8999, Level 16, State 1, Line 1
Database tempdb allocation errors prevent further CHECKDB processing.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:109) in database ID 2 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:1000) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:1016) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
DBCC results for 'tempdb'.
CHECKDB found 3 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB found 3 allocation errors and 0 consistency errors in database 'tempdb'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (tempdb ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
View 1 Replies
View Related
Jan 17, 2000
I have a problem for dropping a table from my database and I got the error message: ""Extent chain for object 736005653 is not correctly linked." The problem indicates table corrupt on the database from DBCC checknewalloc. Instead of reloading the database from a dump, do you have anyway to repair the damage table or drop it.
TIA,
Stella Liu
View 1 Replies
View Related
Dec 25, 1999
I am running SQL server 6.5 with sp3 on NT4.0 with sp6. I ran DBCC checkalloc on one of my database and got the following message.
Table Corrupt: Extent structures are linked incorrectly; check the following extent: alloc pg#=6815488 extent#=6815736 previous extent# on this extent=8625424 previous extent should be=6815728
I have previouly ran dbcc checkdb on the database and I was not able to correct the problem. Please help!
View 1 Replies
View Related
Apr 12, 1999
This morning no one was able to connect to the SQL server. At the server, the RAID set showed no activity. I could not bring up any applications. When clicking the start button, it would take 5 minutes to get a response. I connected to the server from a different machine and tried to restart the SQL services, without success. I could access the Event Viewer Application log. All entries in the log read "DB-LIBRARY error - SQL Server connection timed out." The SQL error log listed the following error " Lazywriter: LRU list is corrupt, bhead 0xe50040, bnew 0, bold 0x130bb00, stat 0x1004/0, page 0x1e1608, bufno 0, freebufs 5528, freelist 0xf1bfe0
99/04/10 22:22:10.10 spid2 Lazywriter: LRU list is corrupt, bhead 0xe50040, bnew 0, bold 0x130bb00, stat 0x1004/0, page 0x1e1608, bufno 0, freebufs 5498, freelist 0x118274"
What does this error indicate? We have received this error in the past and have upgraded our RAID controller because. This is the first time we have had this error since upgrading the controller a month ago.
Thanks.
Philip Talavera
System Administrator
SVG Distribution
View 2 Replies
View Related
Apr 28, 1999
After implementing a recommendation to perform dbcc checkalloc before nightly backup, I began getting the error below on msdb. Books Online suggests restoring from a known clean backup. We have only been using SQL Server for a few weeks and it seems that all our backups of msdb have the same problem. Is there any way of correcting this problem?
Msg 2521, Level 16, State 1
Table Corrupt: Page is linked but not allocated; check the following pages and table: alloc page#=3584 extent id=3816 logical page#=3816 object id in extent=8 (object name = syslogs) index id in extent=0
View 2 Replies
View Related
Jul 11, 2002
Hello!
I'm intrested in all possible ways to corrupt data or log files in SQL server 2000 except of manualy editing them or cutting the comp's power abruptly.
Thank you.
View 1 Replies
View Related
Dec 17, 2001
Very strange. I suspect McAfee Anti-Virus was run against SQL 6.5 files, but don't know for sure. Now server won't start. Rebuild master, it starts. Restore Master, it hangs. Rebuild master, Disk ReInit & ReFit devices, user database and server hangs while recovering db log on restart. A backup was made after the corruption got into db, so restoring db has same result, hang. Cannot open db to begin anything. Help?
View 1 Replies
View Related
Mar 12, 2001
I run a daily maintaince job and it fails.But when i go through the error log. i get
this eror "'Table Corrupt: Extent id 30464 on allocation pg# 30464 has objid 732178004 and used bit on, but reference bit off"
how do i get the table name fron sysobjects as i have had no luck when i do a simple select query to get the details i need
Getting the name would make it easier to solve the problem
thanks
safac
View 1 Replies
View Related
Jun 23, 2004
hello everyone,
how can i fix my corrupt syslogs? i've tried dbcc checktable , dbcc checkalloc, and dbcc fix_al and still reports the same message.we're using ms sql 6.5. PLEASE HELP!
View 3 Replies
View Related
Jan 11, 2005
To make a very long story short, we had a SQL server that experienced problems as a result of bad sectors within one of the drives within a RAID5. Although the drive was replaced the server was never the same and we were forced to perform a migration.
After the migration we began noticing that the server had corrupt data. This was noticed after our applications began erroring out. We determined the corrupt table using DBCC CHECKTABLE and moved the data from those tables into a new table.
Our applications are now working without error, but now it seems as though our indexes are broken which would make sense becuase the tables have essentially been renamed. During an attempted DTS, I selected the option to NOT copy over indexes. I am getting the same error within a DTS as I am within the servers event logs.
Page (3:68379), slot 23 for text, ntext, or image node does not exist.
or
[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION
This is one of the errors that helped determine that the database was corrupt in the beginning. To make it worse, our backups are useless becuase they will not restore. In order for me to use a backup, I have to copy the MDF and LDF from the production server and copy to the test environment server and then attach it. From the test server is where I was able to succesfully backup and restore.
I would have contacted MSFT a long time ago when this all got started. Unfortunately, I work for a company that will not spend the money on asking MSFT for help. I fear that the long this goes on, the worse it gets.
Please keep in mind that their is a lot of detail that is too must to detail here.
My question is, what would be the best way to essentially start over without losing the data? I assume that since a DTS is failing I am basically "SOL".
Does anyone have any suggestions?
Thank you all for your replies.
View 3 Replies
View Related
Oct 11, 2005
Hi
I have a table that keeps getting corrupt all the time. If I do a dbcc checktable, it says the primary key is corrupt. I can fix this by dropping the PK and creating it again, then the table is fine for a while. Problem is, this keeps happening every week! It's quite a big table (15.8 mil records), so this is timeconsuming to drop and recreate PK...
When trying to query the table, it returns the following error:
Attempt to fetch logical page (1:680898) in database 'dbCustomer' belongs to object 'tblPlayer', not to object 'tblTransactions'.
tblTransactions is the table that gets currupt.
The logical page number is different every time as well, so it's not the page it self causing the problem.
The table is updated via transactional replication. The source is in Cape Town, South Africa and the destination in Canada, North America. We do have many other tables being replicated in this manner for many years, but none have given this problem before.
Does anyone have some advice as to what I need to look at maybe? I'm not really sure where to start looking for the cause of the problem.
Thanks,
TeaaZA
View 1 Replies
View Related
Jan 27, 2004
We have a table (> 4,000,000 rows) that appears to be missing data, but if we copy the table using "insert into new_table from bad_table" some of the missing data mysteriously reappears. I am assuming there is something wrong with the database, but I don't know where to begin. Can anyone give me some idea of what might be wrong? Thanks in advance!
View 2 Replies
View Related
May 17, 2008
Dear All,
i made full-text index on one table.while i run a query using Contains clause the following error occurs,
Server: Msg 7619, Level 16, State 1, Line 1
The content index is corrupt.
How can solve this Problem without down the Sql Server 2000, this is happend me very frequently. once i restart the System ,it would be okay.
THanks
M A Sulaiman
View 6 Replies
View Related
May 19, 2006
black_pearl writes "i want to know how to detect if a database in sql server 7 is corrupted. thanks."
View 2 Replies
View Related
Feb 11, 2007
Dear all,
I have a very critical problem with corrupt database. Our main server got burned yesterday. There were very important data that went lost. We have a old computer that was used as the sql server 2000 before this machine was burned with the fire. We only want the initial data of the database so we swithched on the old computer but it was formated once. with recover my files we recovered the .mdf and .ldf files. mssqlrecover from officerecovery says recovery done with demo restriction. it recovers all item but the table value which we needed.
The databse is of 2.37 mb and when compressed 560 kb.
Can anybody please recover the data from the database?
View 2 Replies
View Related
