I had a semi-interesting question the other day from a student – does ReportServerTempDB get recreated upon restart? I told him great question but I did not think so, and that I would have to find out. The question was asked because I told the class that I did not like the name “tempdb” affixed to the database name; it’s too close to tempdb and it’s not really a tempdb in my estimation. Besides the temp_ tables for merging metadata to query result sets, it really does nothing on a temporary basis, at least not like the system database tempdb, and so the behavior is not much like the scratch database tempdb.
The reason that I told him probably not was because unless there is a change in the report definition, there is no reason to drop said definition, especially due to a restart; also, at work I saw the other day a really large, too large, ReportServerTempDB database. I mean this thing was a monster, I have no idea what they’re doing to fill this thing up. Sounds like a problem to me. Anyway, bottom line is…no, it does not get dropped. Visit the sys.sysdatabases table, create_date column, to verify that the database in no way shape or form gets recreated each time the sqlservr.exe gets stopped/started.
Thanks much,
Lee Everest
--------------------------------
No it’s not dropped! What u been smoking dude??? Geezsh"
b6c5026c-5383-417a-9578-78fec2608236|0|.0