What will happen when we delete report server database and report server temporary databses?

Question

Post reply

What will happen when we delete report server database and report server temporary databses?

elchuru

Default port

Points: 1435
More actions
May 6, 2010 at 5:28 am

#234666

Hi All,
Pleases answers to my questions.
1)Is it possible to delete report server database and report server temporary databases?
2)If yes, will it cause problem for me generating a report?
3) If somebody deleted those database how i will know?
4)If those databases are deleted how to recover them?
Thanks in advance

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

1)Is it possible to delete report server database and report server temporary databases? -

Yes, anything is possible 🙂

2)If yes, will it cause problem for me generating a report?

Yes - definitely

3) If somebody deleted those database how i will know?

Databases wont be available, and Report Server wont start successfully

4)If those databases are deleted how to recover them?

Recreate a new Report Server Database with SQL Reporting Services Configuration.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

george sibbald SSC Guru Points: 104210 More actions · Answer 2

elchuru (5/6/2010)
4)If those databases are deleted how to recover them?
Thanks in advance

restore from backup!

---------------------------------------------------------------------

elchuru Default port Points: 1435 More actions · Answer 3

extension of second question

What type problems i will get after deletion of those two databases?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

elchuru (5/6/2010)
extension of second question
What type problems i will get after deletion of those two databases?

Reporting services will not work, all your reports will have been lost, schedules, permissions, etc. (they're stored in the ReportingServices database)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 5

Henrico Bekker (5/6/2010)
1)Is it possible to delete report server database and report server temporary databases? -
Yes, anything is possible 🙂
2)If yes, will it cause problem for me generating a report?
Yes - definitely
3) If somebody deleted those database how i will know?
Databases wont be available, and Report Server wont start successfully
4)If those databases are deleted how to recover them?
Recreate a new Report Server Database with SQL Reporting Services Configuration.

Superb way of answering....I like this one....:cool::cool::cool:

Raunak J