Reporting Database

Question

Post reply

Reporting Database

M&M

SSC-Insane

Points: 21700
More actions
January 21, 2010 at 10:25 am

#138398

There are two databases below on one the servers and it has consumed around 10 -15 GB of space.
Reporting
ReportingServertempdb
As per my understanding, these databases get created when we configure SQL Server Reporting services. Please correct me if I am wrong as I don't have experience on Reporting services.
Now, the business team wants me to delete these 2 databases. Is it ok or is there any other
alternative solution. Please suggest.
M&M

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

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

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

If the 2 DBs are occupying such a disk space, I guess they are storing some data in them.

Have you checked the tables and data in those tables.

You would also better checking the SSRS ReportServer URL.. If you find no folders, reports then you can be assured that there are no reports deployed.

Reporting Server url would be available if you can go to the SQL Server Programs menu -> Configuration Tools - > Reporting Server Configuration Manager..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Gift Peddie SSC Guru Points: 73570 More actions · Answer 2

mohammed moinudheen (1/21/2010)
There are two databases below on one the servers and it has consumed around 10 -15 GB of space.
Reporting
ReportingServertempdb
As per my understanding, these databases get created when we configure SQL Server Reporting services. Please correct me if I am wrong as I don't have experience on Reporting services.
Now, the business team wants me to delete these 2 databases. Is it ok or is there any other
alternative solution. Please suggest.

I just checked it default to 4megs for ReportServerDB and 3meg for ReportServerTempDB so if those databases are deleted a lot of reports cannot be recovered. There are reasons regular backup is required for both databases. I am not aware of alternatives because your employer wants to use Reports and save a few dollars on storage.

Kind regards,
Gift Peddie

M&M SSC-Insane Points: 21700 More actions · Answer 3

Dear All, Thanks for the response.

Got confirmation from business team that they no longer need these reports.

So, will delete them 🙂

M&M

Gift Peddie SSC Guru Points: 73570 More actions · Answer 4

mohammed moinudheen (1/21/2010)
Dear All, Thanks for the response.
Got confirmation from business team that they no longer need these reports.
So, will delete them 🙂

You cannot use the instance again to develop new reports if you delete that databases and here in the US you will be saving $10.00 because 1terabyte drive is $160.00 or less

😉

Kind regards,
Gift Peddie

M&M SSC-Insane Points: 21700 More actions · Answer 5

What I heard is uninstalling SQL Server Reporting Services is very tricky and people

by mistake would uninstall SQL Server itself.

So I guess, deleting these reporting databases would be safer right?

M&M

Gift Peddie SSC Guru Points: 73570 More actions · Answer 6

mohammed moinudheen (1/21/2010)
What I heard is uninstalling SQL Server Reporting Services is very tricky and people
by mistake would uninstall SQL Server itself.
So I guess, deleting these reporting databases would be safer right?

No you need to shrink it to about 100megs for the ReportServerDB and 50megs ReportServerTempDB and make sure you have backup before you reduce the size. Then when both are the small size do a backup for hardware issues as needed. $10.00 is not worth destroying an instance of SSRS and you may be blamed for it so tell them to put it in writing with your email about the actual savings.

Kind regards,
Gift Peddie