Corrupted ReportServerTempDB

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?
ThxHello,
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 <aifong@.gmail.com> napisal w wiadomosci
news: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
>|||Hi Radoslaw,
Thanks! I just tested it on a separate installation and it works.
Just a note on the collation, it has to be exactly the same as
ReportServer DB otherwise it gives an error. Other than that, A-ok.
Thanks,
AF
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 -