Can you please explain how to make a backup for the log file. This is because i have given my site for web hosting and i have started taking the backup of all the log files, there i found Tempdb Transaction Log being full and getting an error 9002 severity 17 state 2? When i generate the log file it forward me the 4 GIG size. which i think i have not taken the backup properly, Please suggest..
Bookmarks