Viewing 4 posts - 1 through 4 (of 4 total)
Try this video and create a clutered environment yourself at home (assuming you have a decent pc)
February 25, 2011 at 6:40 am
Sushant can you try this query and let me know what happens:
dbcc shrinkfile ('templog',100)
backup log tempdb with truncate_only
dbcc shrinkfile ('templog',100)
February 25, 2011 at 6:29 am
have you checked the backup settings in infosphere, it may well be the case it is holding the old file path in two places.
February 25, 2011 at 4:36 am
Have you tried creating a maintenance plan?
February 25, 2011 at 4:33 am
Viewing 4 posts - 1 through 4 (of 4 total)