Error 9003

Hi
I have been using SQL server with the web matrix project whilst I learn
ASP.net. (I am new to both). At some point this week the SQL server stopped
working (It may be linked to my computer crashing whilst another program was
running). It now will not run from the web matrix or the SQL service
manager. I have found the error logs and the last four lines read :-
2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
Exiting.
I have found a description of error 9003
"The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
but this means nothing to me.
My guess is I have an inconsistancy because of the crash but to be honest I
am out of my depth.
Has anyone got some simple advice or do I just start again.
Thanks in advance
Mike
Hi,
Have a look into the below URL to correct the master database corruption.
This will work out provide you have the master database backup.
http://geekswithblogs.net/travis/arc.../27/48400.aspx
Thanks
Hari
SQL Server MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
> Hi
> I have been using SQL server with the web matrix project whilst I learn
> ASP.net. (I am new to both). At some point this week the SQL server
> stopped
> working (It may be linked to my computer crashing whilst another program
> was
> running). It now will not run from the web matrix or the SQL service
> manager. I have found the error logs and the last four lines read :-
> 2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
> 2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
> 2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
> Exiting.
> I have found a description of error 9003
> "The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
> but this means nothing to me.
> My guess is I have an inconsistancy because of the crash but to be honest
> I
> am out of my depth.
> Has anyone got some simple advice or do I just start again.
> Thanks in advance
> Mike
|||Hi Prasad
Thanks for the advice. In fact I have been looking around the internet over
the last few hours and tried a few things including SP4. I also realised
that I had nothing backed up in the SQL Server (as I did not know how to).
Anyway, I installed a new Instance of the server on my computer and have
spent hours building the tables and stored procedures again. I have almost
finished! It's a little messy as I still have the old instance of the SQL
Server on the computer and cannot open it or remove it.
Anyway, I will back up my database this time!!
I will also have a look at your link just for interest sake - and I have
certainly learnt some important info about SQL Server today.
Thanks again
Mike
"Hari Prasad" wrote:

> Hi,
> Have a look into the below URL to correct the master database corruption.
> This will work out provide you have the master database backup.
> http://geekswithblogs.net/travis/arc.../27/48400.aspx
> Thanks
> Hari
> SQL Server MVP
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
>
>
sql

Error 9003

Hi
I have been using SQL server with the web matrix project whilst I learn
ASP.net. (I am new to both). At some point this week the SQL server stopped
working (It may be linked to my computer crashing whilst another program was
running). It now will not run from the web matrix or the SQL service
manager. I have found the error logs and the last four lines read :-
2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
Exiting.
I have found a description of error 9003
"The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
but this means nothing to me.
My guess is I have an inconsistancy because of the crash but to be honest I
am out of my depth.
Has anyone got some simple advice or do I just start again.
Thanks in advance
MikeHi,
Have a look into the below URL to correct the master database corruption.
This will work out provide you have the master database backup.
http://geekswithblogs.net/travis/ar...7/27/48400.aspx
Thanks
Hari
SQL Server MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
> Hi
> I have been using SQL server with the web matrix project whilst I learn
> ASP.net. (I am new to both). At some point this week the SQL server
> stopped
> working (It may be linked to my computer crashing whilst another program
> was
> running). It now will not run from the web matrix or the SQL service
> manager. I have found the error logs and the last four lines read :-
> 2005-09-10 08:54:02.92 spid3 Starting up database 'master'.
> 2005-09-10 08:54:03.35 spid3 Error: 9003, Servrity: 20, State: 1.
> 2005-09-10 08:54:03.35 spid3 Cannot recover the master database.
> Exiting.
> I have found a description of error 9003
> "The LSN %S_LSN passed to log scan in database '%.*Is' is invalid."
> but this means nothing to me.
> My guess is I have an inconsistancy because of the crash but to be honest
> I
> am out of my depth.
> Has anyone got some simple advice or do I just start again.
> Thanks in advance
> Mike|||Hi Prasad
Thanks for the advice. In fact I have been looking around the internet over
the last few hours and tried a few things including SP4. I also realised
that I had nothing backed up in the SQL Server (as I did not know how to).
Anyway, I installed a new Instance of the server on my computer and have
spent hours building the tables and stored procedures again. I have almost
finished! It's a little messy as I still have the old instance of the SQL
Server on the computer and cannot open it or remove it.
Anyway, I will back up my database this time!!
I will also have a look at your link just for interest sake - and I have
certainly learnt some important info about SQL Server today.
Thanks again
Mike
"Hari Prasad" wrote:

> Hi,
> Have a look into the below URL to correct the master database corruption.
> This will work out provide you have the master database backup.
> http://geekswithblogs.net/travis/ar...7/27/48400.aspx
> Thanks
> Hari
> SQL Server MVP
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:93CFAEEF-9171-4CD7-B712-58870BE12715@.microsoft.com...
>
>

Error 823 : SQL Server

Hi
I'm getting an Error 823, when I tried to attach a detached SQL DB
[JPG file attached]
Tried this KB http://support.microsoft.com/defaul...kb;EN-US;828339
But does not seem to work..
Any Ideas ?!
-- LoguDid you run consistency checks on the database before detaching it? You migh
t just have a corrupt database,
and detach/attach won't clean such corruptions...
http://www.karaszi.com/sqlserver/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Logu" <klogu@.scapevelocity.com> wrote in message news:uoN$ZBOMEHA.620@.TK2MSFTNGP10.phx.gbl.
.
> Hi
>
> I'm getting an Error 823, when I tried to attach a detached SQL DB
> [JPG file attached]
> Tried this KB [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;828339[/ur
l]
> But does not seem to work..
>
> Any Ideas ?!
> -- Logu
>|||Hi Logu,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Microsoft Online Support
****************************************
*******************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.sql

error 823

hi!!!
i have this error 823, when i choise tables in a database, the description is input output error bad page id was detected during ...
if you have any sugections to recovery database, i'm great for them
thanks
manuel ralha
http://www.karaszi.com/sqlserver/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"manuel ralha" <mralha@.foruminformatica.pt> wrote in message
news:66C39796-BD18-4E6C-AED0-DB07AF001973@.microsoft.com...
> hi!!!
> i have this error 823, when i choise tables in a database, the description is input output error bad page id
was detected during ...
> if you have any sugections to recovery database, i'm great for them
> thanks
> manuel ralha
|||hi, thanks
thats a good idea, but when i execute de dbcc checkdb , the error ocurs again
thanks
manuel ralha
|||You didn't say which advice you followed.
Are you saying that you restore the latest clean db backup and all subsequent log backups and one of the log
backups re-introduced the corruption?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"manuel ralha" <mralha@.foruminformatica.pt> wrote in message
news:371F4671-4653-4A3A-923C-22790C47AD7E@.microsoft.com...
> hi, thanks
> thats a good idea, but when i execute de dbcc checkdb , the error ocurs again
> thanks
> manuel ralha
|||hi:
the error is this in query analiser or in osql:
I/O error (bad page ID) detected during read at offset 0x0000001ef3c000 in file 'D:\cedile\cedile_data.mdf'
manuel ralha
|||What I'm trying to communicate is (as is the article on the web site I suggested) that your best option is
probably to use your backups to restore a clean database, If you feel uncertain about the actions to take, I
suggest you let MS Support help you.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"manuel ralha" <mralha@.foruminformatica.pt> wrote in message
news:8A7D909A-E787-419A-B926-CA0323CF1600@.microsoft.com...
> hi:
> the error is this in query analiser or in osql:
> I/O error (bad page ID) detected during read at offset 0x0000001ef3c000 in file 'D:\cedile\cedile_data.mdf'
> manuel ralha
>
|||hi
thanks for your help, i'm read your web page, and, i follow all steps. but unhappyly, thoesn't work in this database, i have the same errors.
thanks for your collaboration and help.
manuel ralha

error 8102:cannot update identity column

HI

I have 2 SQL Servers 2000 enterprise version. I setup a transactional replication between them. There is a table using identity feature and set to not for replication. On the server A as publication, B as Subscriber. I created table in B manually and set the name conflict in article default to keep existing data. When it replicates at the first time, everything is fine, but if there is some data added to the table in Server A, the replication fails, saying cannot update indentity column.

I read about something on add Set Identity on/off thing. But I dont know which SP I should add this to. Please help. As detail as possible. Thanks.There is a bug in the Managed Range Identity system. In Merge Replication I have found that while creating a publication using range identities it will work only the first time. Changing settings such as Publisher range or subscriber range does not have an effect. Also, deleting the subscriptions and publications DOES NOT remove the constraints from the affected subscriber tables. Also, the entry for the database in the replication distribution DB table MSrepl_identity_range does not get deleted and therefore the next time the publication is run it will not take the correct settings. In order to successfully recreate the subscription you must delete the row(s) from the afore mentioned table and remove all constraints manually. Only then will it work. If the constraints are not removed the subscriber will show the identity range as used up and will demand a re-sync, and the re-sync will have no effect.

Applies to SQL Server 2000 All SPs

You MUST delete all publications on the affected database and subscriptions first, then run SP_RemoveDBReplication DBName on the publisher and subscribers first then follow the steps above. You can sp_help to see what constraints are on the tables.|||I am sorry, if I undertsand you correctly what you are saying is that I cannot have a replication set up for identity enabled table?|||Originally posted by cobraeyez
I am sorry, if I undertsand you correctly what you are saying is that I cannot have a replication set up for identity enabled table?

no, you can set it up. Just keep in mind that there is a bug in SQL Server relating to the identitiy managing subsystem. What you want to do is delete the pub, subscriptions, drop the Check Constraints on all the subscription tables, find the Identity_Range table in the Replication Distribution database and delete all entries for the database that you are working on. Then recreate the publication and subcription and you will be fine.|||hey. thanks that SP_RemoveDBReplication thing works. :)|||ok, maybe I speak too quick, I think the insert works, but the update doesn't . If I modify a record in the publisher the replication failed again.

And what I did for fix the insert record is remove the publications and subscriptions and ran that RemoveReplication command on the DBs, there is no records in MSrepl_indentity_range table for me to delete.|||ok. The article containing the identitiy field is not set to range identitiy. When you set up the publication you need to click the "..." button to the right of the article name, then click the "Identity Range" tab. Enter your values and click OK to start the Identitiy Ranging.|||thanks, you mean the table article property button (...) right? In there, there is no Identity Range Tab. There are 3 tabs in it. General, Command, Snapshot.|||You will only have that tab on articles that have an identitiy column. Are you sure the article has an Identitiy?|||yes, and I am using sql 2000, identity is enabled and set not for replication|||You've got much of suggestions to the question, but I hope this MSDN Link (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01d4.asp) also gives you much insight to resolve.

HTH|||I had a similar problem and it was because I had triggers and DRI on the same table

Error 7105, how to fix it?

Hi
I am getting error 7105 Severity: 22 on one of my tables (about 1000
record), It seems 2 of the records has been corrupted. I can select other
records and edit the records as long as these 2 records are not part of
select query.
I have read microsoft support and they say that service pack2 should solve
this problem but my server already has service pack 3.
I can not choose these records to delete it, what is the solution, any idea?> I am getting error 7105 Severity: 22 on one of my tables (about 1000
> record), It seems 2 of the records has been corrupted. I can select other
> records and edit the records as long as these 2 records are not part of
> select query.
> I have read microsoft support and they say that service pack2 should solve
> this problem but my server already has service pack 3.
> I can not choose these records to delete it, what is the solution, any
idea?
What does DBCC CHECKDB report?
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Error 26

HI

I recently uploaded my site to a hosting company... i am now getting this error

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] CSharpMegaDVD.MegaDVD.Product.GetNewDVD() in c:\myaspx\csharpmegadvd\business objects\product.cs:566 CSharpMegaDVD.index.LoadNewDVDList() in c:\myaspx\csharpmegadvd\index.aspx.cs:39 CSharpMegaDVD.index.Page_Load(Object sender, EventArgs e) in c:\myaspx\csharpmegadvd\index.aspx.cs:24 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

is this a fault at my end or thier end?

how do i fix this problem?

thx

Hi

i fixed it

in my connection string i had local instead of (local)

you think the error message could be a little more accurate

anyway

cheers!!