Post reply

I am not abel to check to give unrestricted growth in my DB,

  • July 4, 2009 at 12:40 am

    #155911

    Hi all

    i am not abel to give the unrestricted growth in ldf,

    when ever i am applying it is not valadiating ,

    In my system i am having sqlserver 2008, service pack 2

    Please send what is the problem .

    Regards

    sat_sql

  • July 4, 2009 at 1:41 am

    #1019912

    Are you getting any error in selecting that?

    I hope you're doing it in the same way as mentioned in this article (except point 4).

    http://technet.microsoft.com/en-us/magazine/dd407825.aspx%5B/url%5D


    Pradeep Singh

  • July 4, 2009 at 1:54 am

    #1019915

    If you're seeing a max size for the log of 2 TB, that's the maximum possible size for a log file within SQL. So restricted to 2TB is the same as unrestricted.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply