• shyamalarakesh (9/27/2013)


    HI !

    As per my knowledge we cannot add .mdf files to tempdb database.just we can take only log backup's to reduce the size of databse

    Unfortunately, your knowledge is wrong on three counts. First, you can add files to tempdb. Second, you can't take log backups (or any backups) of tempdb. Third, even if you could, it wouldn't reduce the size of the database.

    John