RE: SSRS database questions

Have you tried dbcc shrinkdb ?

You will need to change the recovery model to simple first, run the command, then set the recovery model back to full.

Hope that works for ya!

Robert

From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Matthew Hoyt
Sent: Thursday, July 28, 2011 4:35 PM
To: Robert Martin
Subject: [Tessitura Marketing Forum] SSRS database questions

Hi all,

Has anybody had any issues in terms of the size of SSRS databases becoming too big?

What do you do to keep the size of the SSRS databases in check?

Thanks!

Matt

--
View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/4958/16124.aspx#16124 or reply to this message
--
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!