Hi I am trying to do a backup of a database and it gives me the following
error
Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
I ran dbcc checkdb and it gives consistency errors on one of the table, i
dropped all indexes on the table but its giving me errors while dropping the
last index, i think the index is corrupted . Is there any way to fix the
table or to drop the index without losing the data. I tried dbcc checkalloc
with rebuild and fast option still the same , i am hesitant to try the first
option of dbcc checkalloc which says it will fix the problem but will loose
some of the data. I tried copying the contents of the table to a temporary
table, but it gives I/O error.
Any suggestion '
Thanks
RodgerTry "DBCC CHECKDB"
Thanks & Regards,
P.C Sekhar.
"Rodger" <Rodger@.discussions.microsoft.com> wrote in message
news:78B5EACF-9948-46D6-8D96-C99B6B286E16@.microsoft.com...
> Hi I am trying to do a backup of a database and it gives me the following
> error
> Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
> Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
> I ran dbcc checkdb and it gives consistency errors on one of the table, i
> dropped all indexes on the table but its giving me errors while dropping
> the
> last index, i think the index is corrupted . Is there any way to fix the
> table or to drop the index without losing the data. I tried dbcc
> checkalloc
> with rebuild and fast option still the same , i am hesitant to try the
> first
> option of dbcc checkalloc which says it will fix the problem but will
> loose
> some of the data. I tried copying the contents of the table to a
> temporary
> table, but it gives I/O error.
> Any suggestion '
> Thanks
> Rodger
>|||Please read the entire message which i posted, i already tried dbcc checkdb
and tried dbcc checkalloc with 2 options.
Thanks
Rodger
"P.C Sekhar" wrote:
> Try "DBCC CHECKDB"
> Thanks & Regards,
> P.C Sekhar.
> "Rodger" <Rodger@.discussions.microsoft.com> wrote in message
> news:78B5EACF-9948-46D6-8D96-C99B6B286E16@.microsoft.com...
>
>
Showing posts with label occurred. Show all posts
Showing posts with label occurred. Show all posts
Sunday, February 26, 2012
error 3271
Hi I am trying to do a backup of a database and it gives me the following
error
Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
I ran dbcc checkdb and it gives consistency errors on one of the table, i
dropped all indexes on the table but its giving me errors while dropping the
last index, i think the index is corrupted . Is there any way to fix the
table or to drop the index without losing the data. I tried dbcc checkalloc
with rebuild and fast option still the same , i am hesitant to try the first
option of dbcc checkalloc which says it will fix the problem but will loose
some of the data. I tried copying the contents of the table to a temporary
table, but it gives I/O error.
Any suggestion '
Thanks
RodgerI assume you're on sql2k; thus, it's not possible to disable a corrupted
index to rebuild it.
You can try running "dbcc checktable(tb_name,repair_rebuild)". If it still
fails, you can force a drop of the index by deleting it from sysindexes.
(all warnings/disclaimers applied about direct system modification).
Restoring from a known backup is recommended for most corruption issues!
e.g.
exec sp_configure 'allow','1'
reconfigure with override
go
use <db>
go
--create a backup of sysindexes
--in case of mistake
select *
into sysindexes_bak
from sysindexes
go
delete sysindexes
where name='your_index'
go
exec sp_configure 'allow','0'
reconfigure with override
go
-oj
"Rodger" <Rodger@.discussions.microsoft.com> wrote in message
news:7D83EAD0-94D3-4B01-9C7F-7EBAE775450A@.microsoft.com...
> Hi I am trying to do a backup of a database and it gives me the following
> error
> Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
> Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
> I ran dbcc checkdb and it gives consistency errors on one of the table, i
> dropped all indexes on the table but its giving me errors while dropping
> the
> last index, i think the index is corrupted . Is there any way to fix the
> table or to drop the index without losing the data. I tried dbcc
> checkalloc
> with rebuild and fast option still the same , i am hesitant to try the
> first
> option of dbcc checkalloc which says it will fix the problem but will
> loose
> some of the data. I tried copying the contents of the table to a
> temporary
> table, but it gives I/O error.
> Any suggestion '
> Thanks
> Rodger
>
error
Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
I ran dbcc checkdb and it gives consistency errors on one of the table, i
dropped all indexes on the table but its giving me errors while dropping the
last index, i think the index is corrupted . Is there any way to fix the
table or to drop the index without losing the data. I tried dbcc checkalloc
with rebuild and fast option still the same , i am hesitant to try the first
option of dbcc checkalloc which says it will fix the problem but will loose
some of the data. I tried copying the contents of the table to a temporary
table, but it gives I/O error.
Any suggestion '
Thanks
RodgerI assume you're on sql2k; thus, it's not possible to disable a corrupted
index to rebuild it.
You can try running "dbcc checktable(tb_name,repair_rebuild)". If it still
fails, you can force a drop of the index by deleting it from sysindexes.
(all warnings/disclaimers applied about direct system modification).
Restoring from a known backup is recommended for most corruption issues!
e.g.
exec sp_configure 'allow','1'
reconfigure with override
go
use <db>
go
--create a backup of sysindexes
--in case of mistake
select *
into sysindexes_bak
from sysindexes
go
delete sysindexes
where name='your_index'
go
exec sp_configure 'allow','0'
reconfigure with override
go
-oj
"Rodger" <Rodger@.discussions.microsoft.com> wrote in message
news:7D83EAD0-94D3-4B01-9C7F-7EBAE775450A@.microsoft.com...
> Hi I am trying to do a backup of a database and it gives me the following
> error
> Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
> Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
> I ran dbcc checkdb and it gives consistency errors on one of the table, i
> dropped all indexes on the table but its giving me errors while dropping
> the
> last index, i think the index is corrupted . Is there any way to fix the
> table or to drop the index without losing the data. I tried dbcc
> checkalloc
> with rebuild and fast option still the same , i am hesitant to try the
> first
> option of dbcc checkalloc which says it will fix the problem but will
> loose
> some of the data. I tried copying the contents of the table to a
> temporary
> table, but it gives I/O error.
> Any suggestion '
> Thanks
> Rodger
>
error 3271
Hi I am trying to do a backup of a database and it gives me the following
error
Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
I ran dbcc checkdb and it gives consistency errors on one of the table, i
dropped all indexes on the table but its giving me errors while dropping the
last index, i think the index is corrupted . Is there any way to fix the
table or to drop the index without losing the data. I tried dbcc checkalloc
with rebuild and fast option still the same , i am hesitant to try the first
option of dbcc checkalloc which says it will fix the problem but will loose
some of the data. I tried copying the contents of the table to a temporary
table, but it gives I/O error.
Any suggestion '
Thanks
RodgerI assume you're on sql2k; thus, it's not possible to disable a corrupted
index to rebuild it.
You can try running "dbcc checktable(tb_name,repair_rebuild)". If it still
fails, you can force a drop of the index by deleting it from sysindexes.
(all warnings/disclaimers applied about direct system modification).
Restoring from a known backup is recommended for most corruption issues!
e.g.
exec sp_configure 'allow','1'
reconfigure with override
go
use <db>
go
--create a backup of sysindexes
--in case of mistake
select *
into sysindexes_bak
from sysindexes
go
delete sysindexes
where name='your_index'
go
exec sp_configure 'allow','0'
reconfigure with override
go
-oj
"Rodger" <Rodger@.discussions.microsoft.com> wrote in message
news:7D83EAD0-94D3-4B01-9C7F-7EBAE775450A@.microsoft.com...
> Hi I am trying to do a backup of a database and it gives me the following
> error
> Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
> Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
> I ran dbcc checkdb and it gives consistency errors on one of the table, i
> dropped all indexes on the table but its giving me errors while dropping
> the
> last index, i think the index is corrupted . Is there any way to fix the
> table or to drop the index without losing the data. I tried dbcc
> checkalloc
> with rebuild and fast option still the same , i am hesitant to try the
> first
> option of dbcc checkalloc which says it will fix the problem but will
> loose
> some of the data. I tried copying the contents of the table to a
> temporary
> table, but it gives I/O error.
> Any suggestion '
> Thanks
> Rodger
>|||I assume you're on sql2k; thus, it's not possible to disable a corrupted
index to rebuild it.
You can try running "dbcc checktable(tb_name,repair_rebuild)". If it still
fails, you can force a drop of the index by deleting it from sysindexes.
(all warnings/disclaimers applied about direct system modification).
Restoring from a known backup is recommended for most corruption issues!
e.g.
exec sp_configure 'allow','1'
reconfigure with override
go
use <db>
go
--create a backup of sysindexes
--in case of mistake
select *
into sysindexes_bak
from sysindexes
go
delete sysindexes
where name='your_index'
go
exec sp_configure 'allow','0'
reconfigure with override
go
-oj
"Rodger" <Rodger@.discussions.microsoft.com> wrote in message
news:7D83EAD0-94D3-4B01-9C7F-7EBAE775450A@.microsoft.com...
> Hi I am trying to do a backup of a database and it gives me the following
> error
> Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
> Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
> I ran dbcc checkdb and it gives consistency errors on one of the table, i
> dropped all indexes on the table but its giving me errors while dropping
> the
> last index, i think the index is corrupted . Is there any way to fix the
> table or to drop the index without losing the data. I tried dbcc
> checkalloc
> with rebuild and fast option still the same , i am hesitant to try the
> first
> option of dbcc checkalloc which says it will fix the problem but will
> loose
> some of the data. I tried copying the contents of the table to a
> temporary
> table, but it gives I/O error.
> Any suggestion '
> Thanks
> Rodger
>
error
Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
I ran dbcc checkdb and it gives consistency errors on one of the table, i
dropped all indexes on the table but its giving me errors while dropping the
last index, i think the index is corrupted . Is there any way to fix the
table or to drop the index without losing the data. I tried dbcc checkalloc
with rebuild and fast option still the same , i am hesitant to try the first
option of dbcc checkalloc which says it will fix the problem but will loose
some of the data. I tried copying the contents of the table to a temporary
table, but it gives I/O error.
Any suggestion '
Thanks
RodgerI assume you're on sql2k; thus, it's not possible to disable a corrupted
index to rebuild it.
You can try running "dbcc checktable(tb_name,repair_rebuild)". If it still
fails, you can force a drop of the index by deleting it from sysindexes.
(all warnings/disclaimers applied about direct system modification).
Restoring from a known backup is recommended for most corruption issues!
e.g.
exec sp_configure 'allow','1'
reconfigure with override
go
use <db>
go
--create a backup of sysindexes
--in case of mistake
select *
into sysindexes_bak
from sysindexes
go
delete sysindexes
where name='your_index'
go
exec sp_configure 'allow','0'
reconfigure with override
go
-oj
"Rodger" <Rodger@.discussions.microsoft.com> wrote in message
news:7D83EAD0-94D3-4B01-9C7F-7EBAE775450A@.microsoft.com...
> Hi I am trying to do a backup of a database and it gives me the following
> error
> Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
> Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
> I ran dbcc checkdb and it gives consistency errors on one of the table, i
> dropped all indexes on the table but its giving me errors while dropping
> the
> last index, i think the index is corrupted . Is there any way to fix the
> table or to drop the index without losing the data. I tried dbcc
> checkalloc
> with rebuild and fast option still the same , i am hesitant to try the
> first
> option of dbcc checkalloc which says it will fix the problem but will
> loose
> some of the data. I tried copying the contents of the table to a
> temporary
> table, but it gives I/O error.
> Any suggestion '
> Thanks
> Rodger
>|||I assume you're on sql2k; thus, it's not possible to disable a corrupted
index to rebuild it.
You can try running "dbcc checktable(tb_name,repair_rebuild)". If it still
fails, you can force a drop of the index by deleting it from sysindexes.
(all warnings/disclaimers applied about direct system modification).
Restoring from a known backup is recommended for most corruption issues!
e.g.
exec sp_configure 'allow','1'
reconfigure with override
go
use <db>
go
--create a backup of sysindexes
--in case of mistake
select *
into sysindexes_bak
from sysindexes
go
delete sysindexes
where name='your_index'
go
exec sp_configure 'allow','0'
reconfigure with override
go
-oj
"Rodger" <Rodger@.discussions.microsoft.com> wrote in message
news:7D83EAD0-94D3-4B01-9C7F-7EBAE775450A@.microsoft.com...
> Hi I am trying to do a backup of a database and it gives me the following
> error
> Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense
> Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271)
> I ran dbcc checkdb and it gives consistency errors on one of the table, i
> dropped all indexes on the table but its giving me errors while dropping
> the
> last index, i think the index is corrupted . Is there any way to fix the
> table or to drop the index without losing the data. I tried dbcc
> checkalloc
> with rebuild and fast option still the same , i am hesitant to try the
> first
> option of dbcc checkalloc which says it will fix the problem but will
> loose
> some of the data. I tried copying the contents of the table to a
> temporary
> table, but it gives I/O error.
> Any suggestion '
> Thanks
> Rodger
>
Friday, February 24, 2012
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!!
Subscribe to:
Posts (Atom)