Can i truncate/shirnk reportservertempdb

It seems this is getting bigger and bigger. Is there a way I can truncate or clean this since this is used only for caching/metadata?

thanks
EdlenITAsked:
Who is Participating?
 
gothamiteCommented:
Have you tried the regular shrink command? i.e.

DBCC SHRINKDATABASE(N'** ReportServerTempDB name **' )

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you backing up transaction logs for that database?
Anyway, if it's only for Reporting Server why you don't put the database in Simple Recovery Model? Like: ALTER DATABASE YourDatabaseNameHere SET RECOVERY SIMPLE
0
 
geek_vjCommented:
Yes, you can truncate/shrink the reportservertempdb.

For Truncation:

Backup log reportservertempdb with truncate_only

For shrinking:

DBCC Shrinkfile ('Logicalfilenameoflogfile', <Targetsizemb>)

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.