Now in Suspect

[Jane]

Hi all,
I have had problems lately with my standby server,when i am trying to do a load from my production it goes into suspect mode
.the load is just fine as per my error log after
5/10 minutes it goes into suspect mode the error is
"Error 3305,Severity 21,State 1"
"Page 559396 in databse "xyz' read in during runtime or load xact was uninitilised"
"Idxactbid:6 is in IN_LOAD state with the following exception raised:major 43,minor 3,pstat:0X400"

Now i have checkd error 3305 everywhere but no answers..please help


Regards

[Craig]

I don't see anything on this error as well.

The way it reads, in the dump it is restoring, it is finding a page that was not initialized.

My questions would be:
1.) Have you done any modifications to your production databases?
2.) Have you run checkdb, newalloc, and checkcatalog on your production
databases with no problems?
3.) What service pack levels are you on for NT and 6.5?


------------
Jane at 7/25/00 2:10:29 PM

Hi all,
I have had problems lately with my standby server,when i am trying to do a load from my production it goes into suspect mode
.the load is just fine as per my error log after
5/10 minutes it goes into suspect mode the error is
"Error 3305,Severity 21,State 1"
"Page 559396 in databse "xyz' read in during runtime or load xact was uninitilised"
"Idxactbid:6 is in IN_LOAD state with the following exception raised:major 43,minor 3,pstat:0X400"

Now i have checkd error 3305 everywhere but no answers..please help


Regards

[Jane]

Hi Craig,
i am have recovered the DB by resetting the suspect bit and briging to normal...but i guess it will go back to suspect very soon
some how i do nottrust 6.5

Regards



------------
Craig at 7/25/00 2:34:31 PM

I don't see anything on this error as well.

The way it reads, in the dump it is restoring, it is finding a page that was not initialized.

My questions would be:
1.) Have you done any modifications to your production databases?
2.) Have you run checkdb, newalloc, and checkcatalog on your production
databases with no problems?
3.) What service pack levels are you on for NT and 6.5?


------------
Jane at 7/25/00 2:10:29 PM

Hi all,
I have had problems lately with my standby server,when i am trying to do a load from my production it goes into suspect mode
.the load is just fine as per my error log after
5/10 minutes it goes into suspect mode the error is
"Error 3305,Severity 21,State 1"
"Page 559396 in databse "xyz' read in during runtime or load xact was uninitilised"
"Idxactbid:6 is in IN_LOAD state with the following exception raised:major 43,minor 3,pstat:0X400"

Now i have checkd error 3305 everywhere but no answers..please help


Regards

[Craig]

Again, are you running dbcc's on your prod or standby servers? Are they clean or reporting errors?


------------
Jane at 7/25/00 3:09:17 PM

Hi Craig,
i am have recovered the DB by resetting the suspect bit and briging to normal...but i guess it will go back to suspect very soon
some how i do nottrust 6.5

Regards



------------
Craig at 7/25/00 2:34:31 PM

I don't see anything on this error as well.

The way it reads, in the dump it is restoring, it is finding a page that was not initialized.

My questions would be:
1.) Have you done any modifications to your production databases?
2.) Have you run checkdb, newalloc, and checkcatalog on your production
databases with no problems?
3.) What service pack levels are you on for NT and 6.5?


------------
Jane at 7/25/00 2:10:29 PM

Hi all,
I have had problems lately with my standby server,when i am trying to do a load from my production it goes into suspect mode
.the load is just fine as per my error log after
5/10 minutes it goes into suspect mode the error is
"Error 3305,Severity 21,State 1"
"Page 559396 in databse "xyz' read in during runtime or load xact was uninitilised"
"Idxactbid:6 is in IN_LOAD state with the following exception raised:major 43,minor 3,pstat:0X400"

Now i have checkd error 3305 everywhere but no answers..please help


Regards

[Craig]

Again, are you running dbcc's on your prod or standby servers? Are they clean or reporting errors? Resetting the suspect bit does nothing to correct the problem. Dbcc's need to be run asap.....


------------
Jane at 7/25/00 3:09:17 PM

Hi Craig,
i am have recovered the DB by resetting the suspect bit and briging to normal...but i guess it will go back to suspect very soon
some how i do nottrust 6.5

Regards



------------
Craig at 7/25/00 2:34:31 PM

I don't see anything on this error as well.

The way it reads, in the dump it is restoring, it is finding a page that was not initialized.

My questions would be:
1.) Have you done any modifications to your production databases?
2.) Have you run checkdb, newalloc, and checkcatalog on your production
databases with no problems?
3.) What service pack levels are you on for NT and 6.5?


------------
Jane at 7/25/00 2:10:29 PM

Hi all,
I have had problems lately with my standby server,when i am trying to do a load from my production it goes into suspect mode
.the load is just fine as per my error log after
5/10 minutes it goes into suspect mode the error is
"Error 3305,Severity 21,State 1"
"Page 559396 in databse "xyz' read in during runtime or load xact was uninitilised"
"Idxactbid:6 is in IN_LOAD state with the following exception raised:major 43,minor 3,pstat:0X400"

Now i have checkd error 3305 everywhere but no answers..please help


Regards

[Jane]

Yes i ran DBCC on my standby ..and it looks fine



------------
Jane at 7/25/00 3:09:17 PM

Hi Craig,
i am have recovered the DB by resetting the suspect bit and briging to normal...but i guess it will go back to suspect very soon
some how i do nottrust 6.5

Regards



------------
Craig at 7/25/00 2:34:31 PM

I don't see anything on this error as well.

The way it reads, in the dump it is restoring, it is finding a page that was not initialized.

My questions would be:
1.) Have you done any modifications to your production databases?
2.) Have you run checkdb, newalloc, and checkcatalog on your production
databases with no problems?
3.) What service pack levels are you on for NT and 6.5?


------------
Jane at 7/25/00 2:10:29 PM

Hi all,
I have had problems lately with my standby server,when i am trying to do a load from my production it goes into suspect mode
.the load is just fine as per my error log after
5/10 minutes it goes into suspect mode the error is
"Error 3305,Severity 21,State 1"
"Page 559396 in databse "xyz' read in during runtime or load xact was uninitilised"
"Idxactbid:6 is in IN_LOAD state with the following exception raised:major 43,minor 3,pstat:0X400"

Now i have checkd error 3305 everywhere but no answers..please help


Regards

[Jenny]

Did you recycle SQL after you reset the database status.

------------
Jane at 7/25/00 7:26:33 PM

Yes i ran DBCC on my standby ..and it looks fine



------------
Jane at 7/25/00 3:09:17 PM

Hi Craig,
i am have recovered the DB by resetting the suspect bit and briging to normal...but i guess it will go back to suspect very soon
some how i do nottrust 6.5

Regards



------------
Craig at 7/25/00 2:34:31 PM

I don't see anything on this error as well.

The way it reads, in the dump it is restoring, it is finding a page that was not initialized.

My questions would be:
1.) Have you done any modifications to your production databases?
2.) Have you run checkdb, newalloc, and checkcatalog on your production
databases with no problems?
3.) What service pack levels are you on for NT and 6.5?


------------
Jane at 7/25/00 2:10:29 PM

Hi all,
I have had problems lately with my standby server,when i am trying to do a load from my production it goes into suspect mode
.the load is just fine as per my error log after
5/10 minutes it goes into suspect mode the error is
"Error 3305,Severity 21,State 1"
"Page 559396 in databse "xyz' read in during runtime or load xact was uninitilised"
"Idxactbid:6 is in IN_LOAD state with the following exception raised:major 43,minor 3,pstat:0X400"

Now i have checkd error 3305 everywhere but no answers..please help


Regards