Welsh Corgi (10/3/2015)
GilaMonster (10/2/2015)
You can't back up TempDB and shrinking it is pointless if there's a process which uses a lot of TempDB, it'll just grow again. It's like complaining that the 20 litre rain barrel gets full and deciding to replace it with a 5 litre.I was asked to backup tempdb and said that you can't do that.
They said that they used to diid many years ago,
They're probably mis-rmembering. TempDB cannot be backed up. There's no point anyway, it's a temporary storage space, there's no reason to want to back it up.
There is 99% od free space on the log file,
That's not a problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability