Friday, March 30, 2012
Internal Consistency Error, Restoring Backup
I was wondering if any body has come accross this before, and if so could
offer some advice. It's got me scratching my head.
I have a database that is backed up each night using a maintenance plan.
I have come to attempt to restore this database and it always fails with the
following error,
"An internal consistency error occured. Contact technical support for
assistance.
RESTORE DATABASE terminating abnormaly"
No matter which of the 30 odd backups from the last month I try and on any
machine, I always get the same error.
Many thanks in advance for any help offered
Yours hopefully
Chris
chris.roberts@.optima-ws.comYOu should do as the error suggests and call PSS... It is possible your
database has been corrupt for quite some time, and therefore all of your
backups are also corrupt...
"Chris Roberts" <chris.roberts@.optima-ws.com> wrote in message
news:bivr6s$39p$1@.newsg1.svr.pol.co.uk...
> Hello,
> I was wondering if any body has come accross this before, and if so could
> offer some advice. It's got me scratching my head.
> I have a database that is backed up each night using a maintenance plan.
> I have come to attempt to restore this database and it always fails with
the
> following error,
> "An internal consistency error occured. Contact technical support for
> assistance.
> RESTORE DATABASE terminating abnormaly"
> No matter which of the 30 odd backups from the last month I try and on any
> machine, I always get the same error.
> Many thanks in advance for any help offered
> Yours hopefully
> Chris
> chris.roberts@.optima-ws.com
>|||No sure if it is corrupt, one more bit off info I've found out is that if I
preform a manual backup, it restores OK, it's only when I do a backup from
the maintenance plan that I get this error. It's also the same with all the
databases, not just one
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:O3C0XfUcDHA.652@.tk2msftngp13.phx.gbl...
> YOu should do as the error suggests and call PSS... It is possible your
> database has been corrupt for quite some time, and therefore all of your
> backups are also corrupt...
> "Chris Roberts" <chris.roberts@.optima-ws.com> wrote in message
> news:bivr6s$39p$1@.newsg1.svr.pol.co.uk...
> > Hello,
> >
> > I was wondering if any body has come accross this before, and if so
could
> > offer some advice. It's got me scratching my head.
> >
> > I have a database that is backed up each night using a maintenance plan.
> >
> > I have come to attempt to restore this database and it always fails with
> the
> > following error,
> >
> > "An internal consistency error occured. Contact technical support for
> > assistance.
> > RESTORE DATABASE terminating abnormaly"
> >
> > No matter which of the 30 odd backups from the last month I try and on
any
> > machine, I always get the same error.
> >
> > Many thanks in advance for any help offered
> >
> > Yours hopefully
> >
> > Chris
> > chris.roberts@.optima-ws.com
> >
> >
>
Wednesday, March 21, 2012
Interesting problem with table/filesystem growth
Have an Sqlserver 2000 instance with SP3a on it and had a
problem where we had multiple data files within the
primary filegroup. An end user was adding rows into the
table and received an out of space error on the data
component. Checking the properties on the files the auto
extend option had been turned off , which was fine in our
environment, however, checking the space used in each of
these files showed that there was plenty of space
available for use in all. (No, it wasnt the trans log that
gave grief), I allowed the autoextend on each file and got
over the problem for the table in the short term , (and
saw one of the files extend.)
This lead me to do some thinking about the way Sqlserver
handles the growth of tables on multiple files. The good
book says that Sqlserver will allocate in a round robin
fashion the data pages to a table, however this doesnt
seem to be the case. Also, How does the table what file it
is on. I found this in the sysindexes table and decoding
the first value (Contains fileid and page id and row
offset).
Thats fine, however the major problem is, if Sqlserver
doesnt do the round robin allocation of datapages like it
should, then are all your free space calcs on the file
allocation valid?
Any thoughts' Any stored procedures about to handle this'
cheers
MikeWe've had an experience in the past, where the disks seemed to get overused
and reported an error similar to (unable to allocate space). Unfortunately,
I cannot
remember the specifics. We've had a problem where the auto-extend conflicts
with
an insert.
With regard to the round robin filling, sql server will fill the files using
a proporitional
algorithm. Therefore if you fill one file then add another, the 2nd file
will get filled. If
you create 2 files at the same time, then you will observe that each file is
filled with the
same amount of data each time. In short a 20GB insert will put 10GB in each
file.
HTH
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1a9101c3e08e$548d4c70$a101280a@.phx.gbl...
> Any body have any ideas on this one?
> Have an Sqlserver 2000 instance with SP3a on it and had a
> problem where we had multiple data files within the
> primary filegroup. An end user was adding rows into the
> table and received an out of space error on the data
> component. Checking the properties on the files the auto
> extend option had been turned off , which was fine in our
> environment, however, checking the space used in each of
> these files showed that there was plenty of space
> available for use in all. (No, it wasnt the trans log that
> gave grief), I allowed the autoextend on each file and got
> over the problem for the table in the short term , (and
> saw one of the files extend.)
> This lead me to do some thinking about the way Sqlserver
> handles the growth of tables on multiple files. The good
> book says that Sqlserver will allocate in a round robin
> fashion the data pages to a table, however this doesnt
> seem to be the case. Also, How does the table what file it
> is on. I found this in the sysindexes table and decoding
> the first value (Contains fileid and page id and row
> offset).
> Thats fine, however the major problem is, if Sqlserver
> doesnt do the round robin allocation of datapages like it
> should, then are all your free space calcs on the file
> allocation valid?
> Any thoughts' Any stored procedures about to handle this'
> cheers
> Mike|||Interesting,
still leads to the problem where you think you should have
space available because you tally the total of all file
systems and unfortunately one is full!!! Kind of makes one
stop and think about what level should your space
statistcs be collected at and how you manage them!
>--Original Message--
>We've had an experience in the past, where the disks
seemed to get overused
>and reported an error similar to (unable to allocate
space). Unfortunately,
>I cannot
>remember the specifics. We've had a problem where the
auto-extend conflicts
>with
>an insert.
>
>With regard to the round robin filling, sql server will
fill the files using
>a proporitional
>algorithm. Therefore if you fill one file then add
another, the 2nd file
>will get filled. If
>you create 2 files at the same time, then you will
observe that each file is
>filled with the
>same amount of data each time. In short a 20GB insert
will put 10GB in each
>file.
>HTH
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1a9101c3e08e$548d4c70$a101280a@.phx.gbl...
>> Any body have any ideas on this one?
>> Have an Sqlserver 2000 instance with SP3a on it and had
a
>> problem where we had multiple data files within the
>> primary filegroup. An end user was adding rows into the
>> table and received an out of space error on the data
>> component. Checking the properties on the files the auto
>> extend option had been turned off , which was fine in
our
>> environment, however, checking the space used in each of
>> these files showed that there was plenty of space
>> available for use in all. (No, it wasnt the trans log
that
>> gave grief), I allowed the autoextend on each file and
got
>> over the problem for the table in the short term , (and
>> saw one of the files extend.)
>> This lead me to do some thinking about the way Sqlserver
>> handles the growth of tables on multiple files. The good
>> book says that Sqlserver will allocate in a round robin
>> fashion the data pages to a table, however this doesnt
>> seem to be the case. Also, How does the table what file
it
>> is on. I found this in the sysindexes table and decoding
>> the first value (Contains fileid and page id and row
>> offset).
>> Thats fine, however the major problem is, if Sqlserver
>> doesnt do the round robin allocation of datapages like
it
>> should, then are all your free space calcs on the file
>> allocation valid?
>> Any thoughts' Any stored procedures about to handle
this'
>> cheers
>> Mike
>
>.
>
Interesting problem with table/filesystem growth
Have an Sqlserver 2000 instance with SP3a on it and had a
problem where we had multiple data files within the
primary filegroup. An end user was adding rows into the
table and received an out of space error on the data
component. Checking the properties on the files the auto
extend option had been turned off , which was fine in our
environment, however, checking the space used in each of
these files showed that there was plenty of space
available for use in all. (No, it wasnt the trans log that
gave grief), I allowed the autoextend on each file and got
over the problem for the table in the short term , (and
saw one of the files extend.)
This lead me to do some thinking about the way Sqlserver
handles the growth of tables on multiple files. The good
book says that Sqlserver will allocate in a round robin
fashion the data pages to a table, however this doesnt
seem to be the case. Also, How does the table what file it
is on. I found this in the sysindexes table and decoding
the first value (Contains fileid and page id and row
offset).
Thats fine, however the major problem is, if Sqlserver
doesnt do the round robin allocation of datapages like it
should, then are all your free space calcs on the file
allocation valid?
Any thoughts' Any stored procedures about to handle this'
cheers
MikeWe've had an experience in the past, where the disks seemed to get overused
and reported an error similar to (unable to allocate space). Unfortunately,
I cannot
remember the specifics. We've had a problem where the auto-extend conflicts
with
an insert.
With regard to the round robin filling, sql server will fill the files using
a proporitional
algorithm. Therefore if you fill one file then add another, the 2nd file
will get filled. If
you create 2 files at the same time, then you will observe that each file is
filled with the
same amount of data each time. In short a 20GB insert will put 10GB in each
file.
HTH
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1a9101c3e08e$548d4c70$a101280a@.phx.gbl...
quote:|||Interesting,
> Any body have any ideas on this one?
> Have an Sqlserver 2000 instance with SP3a on it and had a
> problem where we had multiple data files within the
> primary filegroup. An end user was adding rows into the
> table and received an out of space error on the data
> component. Checking the properties on the files the auto
> extend option had been turned off , which was fine in our
> environment, however, checking the space used in each of
> these files showed that there was plenty of space
> available for use in all. (No, it wasnt the trans log that
> gave grief), I allowed the autoextend on each file and got
> over the problem for the table in the short term , (and
> saw one of the files extend.)
> This lead me to do some thinking about the way Sqlserver
> handles the growth of tables on multiple files. The good
> book says that Sqlserver will allocate in a round robin
> fashion the data pages to a table, however this doesnt
> seem to be the case. Also, How does the table what file it
> is on. I found this in the sysindexes table and decoding
> the first value (Contains fileid and page id and row
> offset).
> Thats fine, however the major problem is, if Sqlserver
> doesnt do the round robin allocation of datapages like it
> should, then are all your free space calcs on the file
> allocation valid?
> Any thoughts' Any stored procedures about to handle this'
> cheers
> Mike
still leads to the problem where you think you should have
space available because you tally the total of all file
systems and unfortunately one is full!!! Kind of makes one
stop and think about what level should your space
statistcs be collected at and how you manage them!
quote:
>--Original Message--
>We've had an experience in the past, where the disks
seemed to get overused
quote:
>and reported an error similar to (unable to allocate
space). Unfortunately,
quote:
>I cannot
>remember the specifics. We've had a problem where the
auto-extend conflicts
quote:
>with
>an insert.
>
>With regard to the round robin filling, sql server will
fill the files using
quote:
>a proporitional
>algorithm. Therefore if you fill one file then add
another, the 2nd file
quote:
>will get filled. If
>you create 2 files at the same time, then you will
observe that each file is
quote:
>filled with the
>same amount of data each time. In short a 20GB insert
will put 10GB in each
quote:
>file.
>HTH
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
quote:sql
>news:1a9101c3e08e$548d4c70$a101280a@.phx.gbl...
a[QUOTE]
our[QUOTE]
that[QUOTE]
got[QUOTE]
it[QUOTE]
it[QUOTE]
this'[QUOTE]
>
>.
>
Monday, March 12, 2012
Interactive Sort (problem/bug)
Hi
Header image (setup as external) disappear when interactive sort is used (interactive sort is set in the body of the report), works fine if the image is embedded.
any help is appreciated.
Thank you
Veneto
This is a known issue. The fix is available in a hotfix for RS 2005 SP1, and will also be included in the next service pack.|||Thank you for replying.Sunday, February 19, 2012
Integrating Reporting services into java
I am facing a lot of problems integrating the reporting services into the java application using url access.If any body has sucessfully implemented this please provide me with the code or point me to the resources.
Thanks in advance
prashant
|||
No i am trying to use the URL access through a java servlet.The report is displayed but on page load ,
javascript error 'RSClientController is undefined' is thrown.After that if i click on any other button or select box the javascript error are thrown.Also the reporting server is not returning any cookies when a request is made.Can any one help please