Re: Is there a way to Limit the Log File in terms of GB?
- From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 May 2009 07:15:30 +0200
You can set a max size, but what would you want as result if you perform an operation that requires more than available space? What you would get is an error message. What database is this? Your app db or tempdb? How often do you perform log backups? Etc.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Eric S" <NoSpam@xxxxxxxxxxx> wrote in message news:eG0EDyb3JHA.480@xxxxxxxxxxxxxxxxxxxxxxx
Hi All,
I create a lot of temp tables and indexes and also creating Hash tables and the log file can easily be 215GB. Is there a way to Limit the Log File in terms of GB?
Thanks,
Eric
.
- Follow-Ups:
- References:
- Is there a way to Limit the Log File in terms of GB?
- From: Eric S
- Is there a way to Limit the Log File in terms of GB?
- Prev by Date: linq to sql for stored proc with user defined table as parameter
- Next by Date: Re: Using Sys.Databases to get the database name
- Previous by thread: Is there a way to Limit the Log File in terms of GB?
- Next by thread: Re: Is there a way to Limit the Log File in terms of GB?
- Index(es):
Relevant Pages
|
