creating temp files while collecting data for reports, fills up the Temp db log file. Since I don't need recovery for report programs, is there a way to turn off logging of temp files?
You can't turn off logging. Your best bet is to ensure that Tempdb has a large enough initial size and is set for automatic growth. See "Optimizing tempdb Performance" and "Expanding a database" in Books Online.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply