Sunday, February 12, 2012

Backup Transaction Log on TempDb

How can i backuplog on Tempdb using T-SQL? Its fullNo can do. Make sure that tempdb is still in simple recovery mode. If it is,
you can have long
running transactions, or some humongous modifications requiring lots of log
space in tempdb. Short
term: make sure you have storage and autogrow is possible, Long term, hunt d
own what it is using
this space and fix the code.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
news:C70FC7C3-E8F8-4DE9-A2DA-42D0B44F1AC1@.microsoft.com...
> How can i backuplog on Tempdb using T-SQL? Its full

No comments:

Post a Comment