all groups > sql server reporting services > august 2006 >
You're in the

sql server reporting services

group:

RS 2000 ReportServerTempDB



RS 2000 ReportServerTempDB Scott M
8/17/2006 8:15:41 AM
sql server reporting services: Does anyone have a script laying around to set up the ReportServerTempDB
database with RS 2000?
RE: RS 2000 ReportServerTempDB weilu NO[at]SPAM online.microsoft.com
8/18/2006 2:58:17 AM
Hello Scott,

I am not sure why you need the script to set up the TempDB.

Although you could script out the TempDB from a correct SQL Server, I
really recommand you reinstall the Reporting Services.

If you delete the temporary database, you must run Setup to create a new
version. Reporting Services does not recreate the database if it is
missing, nor does it repair missing or modified tables. Although the
temporary database does not contain persistent data, you should back up a
copy of the database anyway so that you can avoid having to recreate it as
part of a disaster recovery operation.

Thank you for your patience.

Sincerely yours,

Wei Lu
Microsoft Online Partner Support

=====================================================

PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.

We also love to hear your product feedback!

Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
Re: RS 2000 ReportServerTempDB Scott M
8/18/2006 6:45:31 PM
That's exactly why I needed to recover it. :(

The server crashed and network support wasn't backing up the server like
they should have been. I didn't want to loose all the keys on the server.

I installed another copy on my workstation and scripted the DB. Then added
a few roles and it worked.

yeah, total hack job :)

[quoted text, click to view]
AddThis Social Bookmark Button