Friday, February 17, 2012

empty temp log file

How do you empty the tempdb log file? I'm getting temp log file fullBACKUP LOG tempdb WITH TRUNCATE_ONLY
And then you can shrink it using DBCC SHRINKFILE if you need to reduce your
tempdb log file's size
http://msdn2.microsoft.com/en-us/library/ms189493.aspx
If you restart your SQL Server service, then your tempdb database will be
dropped and recreated from scratch. (just in case you need something like
this...)
--
Ekrem Ã?nsoy
"Logger" <Logger@.discussions.microsoft.com> wrote in message
news:46F322B7-C259-4C9B-AA15-7D4B8AED0C72@.microsoft.com...
> How do you empty the tempdb log file? I'm getting temp log file full

No comments:

Post a Comment