>From what I've read, that usually means that the db is corrupted and I

> Hi,
>
> Need help here. I have reporting services installed on a sql cluster
> and backup running every night for the 2 databases: ReportServer and
> ReportServerTempDB. However a few weeks ago, the backup started
> failing because ReportServerTempDB failed the DBCC CheckDB test with
> the following error message:
>
> Incorrect PFS free space information for page (1:184) in object ID
> 2105058535, index ID 1, partition ID 72057594038517760, alloc unit ID
> 72057594043498496 (type LOB data).
> Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
>
>>From what I've read, that usually means that the db is corrupted and I
> should restore from the backup... but seeing that this is the
> temporary db, would it be possible to just delete the corrupted on and
> recreate the ReportServerTempDB? Any impact?
>
> Thx
>

On Feb 8, 8:27 pm, "Radoslaw Lebkowski" <rade...@wp.pl> wrote:
> Hello,
>
> Yes you can drop ReportServerTempDB database and then recreate it:
> After creating a new database ReportServerTempDB, create a Role
> called RSExecRole , then you can run the script CatalogTempDB.sql. to
> recreate the missing ReportServerTempDB objects.
>
> (Go to your original installation bits and grab the file named
> CatalogTempDB.sql located in the directory ..\Setup\Report Server\Reporting
> Services\ReportServer.)
>
> You will also need to make sure all the users that are in the RSExecRole in
> the ReportServer Database
> are in the ReportServerTempDB's RSExecRole.
>
> Regards,
> Radoslaw Lebkowski
>
> Uzytkownik <aif...@gmail.com> napisal w wiadomoscinews:1170909371.919215.218860@l53g2000cwa.googlegroups.com...
>
>
>
> > Hi,
>
> > Need help here. I have reporting services installed on a sql cluster
> > and backup running every night for the 2 databases: ReportServer and
> > ReportServerTempDB. However a few weeks ago, the backup started
> > failing because ReportServerTempDB failed the DBCC CheckDB test with
> > the following error message:
>
> > Incorrect PFS free space information for page (1:184) in object ID
> > 2105058535, index ID 1, partition ID 72057594038517760, alloc unit ID
> > 72057594043498496 (type LOB data).
> > Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
>
> >>From what I've read, that usually means that the db is corrupted and I
> > should restore from the backup... but seeing that this is the
> > temporary db, would it be possible to just delete the corrupted on and
> > recreate the ReportServerTempDB? Any impact?
>
> > Thx- Hide quoted text -
>
> - Show quoted text -