Solved

Server: Msg 7105, Level 22, State 6, Line 1 afer running DELETE query.

Posted on 2006-10-29
9
1,264 Views
Last Modified: 2008-01-09
Hello

I have a Deepmetrix LiveStats server running on MSDE 2000 SP4.
I have been having problems with logins and Deepmetrix support asked me to run this query on my database:

DELETE FROM EventQueue WHERE EventType IN
(4001,4010,4000,4020,3000,6000,5000);

When I run it through Query Analyzer:

I get the error:

Server: Msg 7105, Level 22, State 6, Line 1
Page (1:2318), slot 33 for text, ntext, or image node does not exist.

Connection Broken

When I run it through osql queries via the command line, I get the following error:

Msg 21, Level 22, State 1, Server EGGSTER\DEEPMETRIX, Line 1
Warning: Fatal error 7105 occurred at Oct 29 2006  7:23AM

Deepmetrix support is very incompetent and I'm not very good with SQl myself. What would you suggest me to do?

I even backed up the DB and restored to an SQL 2000 server to see if it makes any difference, but it doesn't.

0
Comment
Question by:eggster34
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 40

Accepted Solution

by:
Vadim Rapp earned 500 total points
ID: 17828693
Run DBCC CHECKDB ('name-of-your-database',REPAIR_REBUILD)
0
 

Author Comment

by:eggster34
ID: 17828826
Server: Msg 7919, Level 16, State 2, Line 1
Repair statement not processed. Database needs to be in single user mode.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
0
 
LVL 10

Expert Comment

by:AaronAbend
ID: 17829254
To get your db in single user mode,

shut it down.
In DOS, Go to the program files\microsoft sql server\MSSQL$DEEPMETRIX\binn directory
start up sql server with this command:  sqlservr -m

then you can use OSQL  to run the dbcc


0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 21

Expert Comment

by:Kevin3NF
ID: 17829678
What it all means is that you have data corruption in your database.  Running CheckDB without the repair options will tell you where (tables, indexes, etc.)

0
 

Author Comment

by:eggster34
ID: 17836799
I start the sql in single user mode with the -m switch, but on that command prompt, it does not allow me to run any queries.
How can I enter commands through osql after starting the server with the -m swtich?
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 17837056
If you get a "1>" you type your query and press enter.

You should then get a "2>"

Type GO and press enter again.
0
 

Author Comment

by:eggster34
ID: 17837136
I don't get a 1 or a 2 or anything.. it just shows a black window that says recovery is complete and does not allow me to enter any commands..
0
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 17837398
it shows black window in the window where you started the server.

Now open another command prompt in the same directory, and start osql there.

So you have 2 command prompts - one for hte server, another for osql where you will be entering the commands.
0
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 17837508
...to stop the server, in osql window enter SHUTDOWN and then GO.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question