• 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass