THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search
Home Blogs Forums Roller Downloads   Opml View as RSS news feed in XML
SQLblog.com - The SQL Server b... » SQL Server » SQL Server » Transaction Log File

Transaction Log File

Last post 07-17-2008, 1:32 by Uri Dimant. 1 replies.
Sort Posts: Previous Next

  •  07-15-2008, 13:18 7854

    Transaction Log File

    Hi all,

    Can anybody please, let me know that how much space should be good to allocate for transaction log file, so that it doesen't run out of space?

    Thanks

  •  07-17-2008, 1:32 7876 in reply to 7854

    Re: Transaction Log File

    Robin

    It depends on your database/server comfiguration. You should know how  workload is, what recovery model of the db is, do you want to backup log file?

     

     

    Uri Dimant
©2006-2009 SQLblog.comTM
Brought to you by Peter DeBetta & Adam Machanic
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement