Table's Get Corrupted
May 1, 2008
Team,
I am having a critical problem.
We a team of 10 members accessing a particular database with a common user name and password . Some one have deleted the data from a business critical table. Transaction log backup is done every half an hour. Considering backup is taken at 10AM and my data is lost at 10.26AM. How to recover the lost data?
Is it possible to recover the data from log file or any other way to achieve the data recovery?
Is is possible to trace the person who have done this job. (By IP address or any other way)?
Regards,
Venkatesan Prabu . J
View 1 Replies
ADVERTISEMENT
Aug 27, 2001
SQL Server 6.5.
Hi!
When I try to create PK, Clustered index on the column in the table I have got error message: 1105 Couldn't not allocate space for object table1......
But it is a big amount of free space in the database. And actually I can create any indexes, exsept clustered with no problem.
DBCC CHECKALLOCK for this table shows: extent not ih the segment.
Does it mean the table structure is corupted? What Can I do to resolve the problem?
Thank you,
Elena.
View 1 Replies
View Related
Mar 13, 1999
Hi,
I have a corrupted table wich has some valuable data in it. I found out that there is only one raw is corrupted. How do I find out which row of the table is it?
Can any one Help me in this matter Please?
Thanks Very much.
Jay k
View 7 Replies
View Related
May 9, 2008
Hi All,
I have just one corrupted record on a table: I copied everything else to another table but I can't delete or rename the old one!
Is restoring the whole DB my only way out there?
Any help or suggestion would be much appreciated!
Cheers
View 8 Replies
View Related
Jan 21, 2008
Hello,
I am facing an issue with a table in my database.
1) When I run a query Select * from MY_Table the query never completes. If I press cancel in Query Analyzer after 1 second or 2 minutes, it always shows the same 174 records. The total table size is 800 KB with 3148 rows .. according to TaskPad
2) No queries, even queries that would return only 1 record complete execution against that table
3) I am unable to rename the table, if I try to rename the table Enterprise Manager becomes unresponsive and has to be closed.
4) If I try to browse the rows through Enterprise manager by scrolling through the records, it allows me to go down through a number of rows and then Enterprise manager gives me a timeout expired error.
5) I ran a DBCC CheckDB command ran for 1 hr and 7 minutes. It says there are 0 allocation errors and 0 consistency errors in the database.
6) The other database tables seem to be OK and the Database is operational except for calls involving the 1 Table
7) I am unable to Drop the Table
8) DBCC CheckAlloc finds 0 allocation errors and 0 consistency errors.
9) DBCC CheckTable on MY_Table returns with: There are 3148 rows in 33 pages for object 'MY_Table' .. no errors are printed.
Can one of the SQL Gurus on this forum please recommend a course of action.
Thanks in advance.
View 1 Replies
View Related
Jan 31, 2008
When my colleague makes any change to a query containing a derived table, the word 'WITH' followed by a lot of graphical characters appears after the alias, rendering the query unusable. We have tried this with various existing and new, simple queries, all to no avail. We are editing the queries in Visual Studio 2003, and he does not get this effect when using Visual Studio 2005. I can edit the query in 2003 on my laptop with no ill effects.
Help!
Karen
View 17 Replies
View Related
Mar 12, 2015
We are facing a weird scenario in which the snapshot is getting corrupted after insertupdate few million records in to a table .
SQL Server 2012
windows server 2008 R2
service pack 1
64-bit OS
View 1 Replies
View Related
Jul 31, 2007
Hi Everyone,
when i am trying to attach a 'xxx.mdf' file it is showing message 'xxx.mdf' is not a primary database file.
Please suggest me what could be the reasons and what are the possible ways to recover my database.
I have lot of important data in the database.
Thanks and Regards,
Shashidhar
View 7 Replies
View Related
Jun 27, 2007
how can i attach my database without the ndf file, i still have the mdf and ldf. my ndf file contains only 2 tables which are not that very impt. unfortunately my ndf was corrupted and my backup files was deleted when the network admin formatted the harddisk where the backups were stored.. is it possible? kindly help..
View 5 Replies
View Related
Sep 16, 1999
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
View 9 Replies
View Related
Nov 14, 2007
We have one database of 5 GB of which when we take the backup and restore in another location, it says "Device Activation Error. The Physical file name e:databaseike_log.ldf may be incorrect".
The database has more than one log file.
Now when we use another procedure to create new database and stop the sql, then replace the old mdf file and REBUILDLOG. (Ie dbcc rebuildlog(nike,1,0)). It says incorrect DBCC Statment.
Pl. suggest us what to do?
View 3 Replies
View Related
Jun 7, 2001
Hi, Folks !
What happens with all jobs after rebuilding master db if it got corrupted. Will they be working correctly ? If no, then why ?
Thanx in advance,
serg
View 2 Replies
View Related
Jan 25, 2005
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.
View 7 Replies
View Related
Apr 5, 2007
Hi..!
Is it possible to recover data from corrupted log backup ?
Suppose we have 10 log files and 8th is corrupted then how can we recover database.
I am not facing such problem right now, but it's a question raised in my mind.
I would like to have your help, suggestions & comments. :rolleyes:
Thanks...
View 2 Replies
View Related
Aug 2, 2007
Hi Everyone,
When I am trying to restore the backup it is giving an error message "An internal consistency error occurred. Contact Technical Support for assistance".
Please suggest me on this issue.
Is there any way to restore the backup or recover the backup.
Thanks,
Shashidhar
View 4 Replies
View Related
Dec 15, 2005
I have a SQL 2000 database whose MDF is approx. 105 GB. Everything has been working fine for months until this past weekend when the database server dropped offline. I restarted the services and SQL server looks to have started up okay. However, trying to access it via Enterprise Manager causes EM to hang. Checking the Windows event log, there are a whole series of messages stating ...
3455 : Analysis of database 'ptportal' (7) is XX% complete (approximately 61 more seconds)
This 'analysis' ran for over 12 hours ... I have never seen this run before, much less this long. Now, there are a new series of messages stating ...
3450 : Recovery of database 'ptportal' (7) is XX% complete (approximately 56526 more seconds) (Phase 2 of 3).
This 'recovery' has been running for 9 hours now. Does anybody have any idea what has happened here or what is going on? My guess is that this database has been corrupted and SQL Server is trying to do a repair? Anybody know how long this usually takes and what the success liklihood would be?
Thanks
-- Jeff Chastain
View 1 Replies
View Related
Mar 19, 2007
this may well be the wrong place for my post, if so please move it.
I have a variety of boxes with SQL tools installed on them. For some reason last week several of them seem to have gone a bit squif.
Server 1. Enterprise manager fails to run, giving message MMC could not create the snap-in. QA runs fine.
Server 2. Load EM click on a database and try Tools --> QA it comes back with File Not Found. Add isqlw as an external tool and you can run that ok, but still File Not found on the QA tab.
I know its not data corruption, but I hope someone can give me a clue on this!
Cheers!
View 2 Replies
View Related
Aug 20, 2007
Hi ALL,
My sql server is not starting becasue master db got corrupted.
I have tried to rebuild the master db with rebuild utility.Now the process of rebuilding taken 6 hours but still the process of rebuild master is going on.
Can any body faced this problem why it is not rebuilding the simple master database.
Thanks you.
BPG
EDIT by tkizer: moved to Data Corruption Issues forum
View 5 Replies
View Related
Oct 4, 2007
Hi,
I have a database corrupted showing on the Object Explorer the name of the database and showing near (6.5). Deleted not accepted any other function not allow. Is there any way to take off from the Object Explorer?
Best regards
View 3 Replies
View Related
Jul 23, 2005
Hello,I have a SS2K (SP3) that is appending very wierd looking error messagesto the SQL Server Log (Current). The messages are not formatted asother log entries. The messages suggest some kinda dump information.The messages have the following characteristics:Date Information is invalidSource information is invalidMessage information is strangeThe following is a message that appear in my current SQL Server LogDATE:78008454SOURCE: Module(MSVCRT+Message (_endthread+000000C1)There are many messages like this in the log.Is this serious?Thanks - Covi
View 1 Replies
View Related
Jul 20, 2005
Hey Hey everyone. It's me again asking for help.I have an NT sp6 box with SQL 7. It seems the password for SA hasbeen corrupted, so it won't allow me to log in to it.As an NT admin, is there anyway to reset the SA password?Or, can I create another SA account in SQL 7?Can't find anything in Microsoft because..... SQL7 is not longersupported.Thanks in advance for any help.Jinev
View 3 Replies
View Related
Jul 20, 2005
Need to recover from a corrupted log file. The database in EnterpriseManager shows the database as corrupt.Using sp_Attach_db produces a corrupt log message.Any way to recover the data?Thanks
View 2 Replies
View Related
Nov 1, 2007
hello,
i am using sql server ce 2.0 on windows ce 4.2.sometimes my sdf file gets corrupted but i cant understand why?i know how this file repair.but for me it is not a solution.please somebody help me!
View 1 Replies
View Related
Dec 1, 2006
Hi:
I try to run VB2005 Sample101, "Using Datagridvies" with SQL Express,
Here is what I got !"
"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. if this
is an existing database, the file may be corrupted and should be restored from a
back up.
Cannot open use default database. Login failed.
Login failed for use 'XXXXXXXXXXXAdministrator"
Lof File 'C:Program FilesMicrosoft SQL ServerMSSQL.1DataAdventureWorks_Data_Log.idl' does not match the primary file. It may be from a different database or the log
may have been rebuilt previously."
Then I re attached the Database again. Still the Same problem.
I try other sample that used Northwin and Pubs (SQL2000 ) and attached to
SQLExpress, Well I suffered the SAME PROBLEM.
WHY, Please Help
Thanks
Simon
View 7 Replies
View Related
Aug 14, 2006
We need to know, how to reorganize or reindex on sql-ce?
View 1 Replies
View Related
Jul 18, 2007
I am having problems with my applications files. Part of my windows foundation or plug and play (error 31 - device not attached to system). I also found that my sql server is corrupted and I got the message to uninstall and reinstall. I don't know how to find where to go to re-install and unfortunately I uninstalled the VSS sql already. How do I find my sql server to re-download? help!
View 1 Replies
View Related
Jan 16, 2008
Hi,
I was working away as usual, when BIDS crashed. Upon re-starting, my package tasks no longer had any connectors between them! However, if I selected, then clicked on them, the connectors reappeared again. I thought this was a one-time problem.
However, now other packages, upon opening, are missing the task connectors as well. This has never happened before until this morning after BIDS crashed. It seems to be permanently corrupted at this point.
Should I reinstall SSIS? Has anyone else seen this before?
Thanks
View 2 Replies
View Related
Mar 16, 2006
ok..my friend sent me a video via file transfer, but when i tried to view it, and open it up with windows movie maker (that is the program she made the video on) it said the file was corrupted. is there any way i can fix the corrupted file? or any other program i can view it on? windows media player also declares it corrupted.
View 1 Replies
View Related
Mar 20, 2000
I am backing up SQL 6.5 DB using Backup Exec 7.2 on NT 4.0 server SP4 with SQL server agent. The backup job ends in Failed status and a warning that DBname is corrupt. I then try to run DBCC Checkdb, newalloc, and checkcatalog commands to repair the DB. No further ahead yet. Are there any other commands that I can perform on the DB so that the corruption can be repaired, or verified there indeed is corruption of DB?
View 1 Replies
View Related
Nov 1, 1998
Any help is greatly appreciated.
I hot the error message from the DBCC log file
"Msg 2510, Level 16, State 1, Server SRVSQL1111, Line 1
Table Corrupt: Keys do not match between leaf page 53686 and data page
53940; check row # 19 on the data page"
Could anyone please tell me how I can locate the corrupted object?
Thanks in advance,
VD
View 2 Replies
View Related
Apr 3, 2008
Hi This is chetan jain sql server DBA.
I came accross a probplem while synchronising production with DR in logshipping.
logshipping was stopped and the message was " Cannot copy the ......TRN . file is corrupted.
can anybody suggest that what should be done if TRN file is corrupted...because if i manully restore the logs at DR i will need every log file to sync Prod with Dr.log file that is corrupted cannot be skipped...neither it can be restored at Dr.
please suggest the solution..
Thanks in Advance...
Thanks in advance.
-- Chetan
View 4 Replies
View Related
Mar 17, 2008
Hi,
I am getting this error on my indexing job:
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Database 'mmv6', index 'Message.IX_To' (ID 2137058649) (index ID 5).
Extra or invalid key for the keys:
[Microsoft][ODBC SQL Server Driver][SQL Server]Index row (1:4341703:43)
with values (RecipientUser = 'vfckrkwgn' and TimeLogged = Feb 7 2008 12:47PM and BlockNumber = 78799731425287 and BlockRecipientIndex = 1)
points to the data row identified by ().
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consiste.....
i run the dbcc checktable('Message') -- where message is my table name' and it showed :
DBCC results for 'Message'.
There are 47634600 rows in 2260742 pages for object 'Message'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The cluster is made as:
USE [mmv6]
GO
/****** Object: Index [IX_To] Script Date: 03/18/2008 15:39:25 ******/
CREATE NONCLUSTERED INDEX [IX_To] ON [dbo].[Message]
(
[RecipientUser] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
the data row is:
2008-02-07 12:47:59.000787997314252870B47aafdf5000122343Tax Refund (Message ID J8N923B)2008-02-07 12:47:49.000refunds-taxirs.org0000000000001011(550 Requested action not taken: mailbox unavailable)vfckrkwgnhotmail.com000-3427532201NULL00NULL
Any suggestions?
View 1 Replies
View Related
Jul 20, 2005
Recently, one of our database's mdf and ldf was corrupted. We were able tobring back the database with the capability of importing and querying thedata. However, the data is not the full list. Some of the data are stillmissing because the tables we want still has sone 'chain mis linkage' errorwhen we did a DBCC checkdb/checktable. DBCC couldn't fix those errorseither. We're pretty sure that there are some data still burry under thecorruption. Then we thought of the life LDF file. This file should haverecorded every transaction up to the point of failure. So we trying torecover that file, but there are 2 problems. First is we don't have back upof that file and 2nd, that file is also corrupted. I couldn't backup thecorrupted ldf file at its current state. It's giving me some unrelated errormessage like disk space is out. All I know now is the only hope to recoverthose missing data are in this LDF file. We tried to use this software fromLimingent Log Explorer to recover it. So far no such luck with that. SoI'm asking anyone who has similar experience or problem. Please let me know.I need to know anyway to recover this LDF file, either by using sql server'snative tools or 3rd party tools. Any input is helpfull. thanks in advance.Wei
View 1 Replies
View Related
