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)
http://www.youtube.com/watch?v=7onR2BjTVr8
February 25, 2011 at 6:40 am
#1291496
Sushant can you try this query and let me know what happens:
dbcc shrinkfile ('templog',100)
backup log tempdb with truncate_only
February 25, 2011 at 6:29 am
#1291490
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
#1291452
Have you tried creating a maintenance plan?
February 25, 2011 at 4:33 am
#1291451