Forum Replies Created

Viewing 15 posts - 226 through 240 (of 309 total)

  • RE: Log file is filling up

    Steve Jones - SSC Editor (3/28/2014)

    Trace is easy. Start Profiler, pick the options you want and then save as a trace script file. Then execute that on the server to...

    March 28, 2014 at 12:38 pm

    #1701285

  • RE: Log file is filling up

    JoshDBGuy (3/28/2014)

    For it to be 30 GB requires quite a bit of data, I would say that you need to look at the script to see what it's doing.

    That's exactly...

    March 28, 2014 at 12:22 pm

    #1701275

  • RE: Log file is filling up

    JoshDBGuy (3/28/2014)

    I see that you are doing a batch, how many records are you archiving? Does the data contain blobs? (look for text fields).

    I don't know how many records are...

    March 28, 2014 at 12:03 pm

    #1701265

  • RE: Log file is filling up

    Jeff Moden (3/28/2014)

    So, have you been shrinking the log file and that's how it got back down to 121 MB?

    I am not, but yes they are being shrunk by another...

    March 28, 2014 at 11:46 am

    #1701259

  • RE: Log file is filling up

    Thanks a lot.

    March 28, 2014 at 11:42 am

    #1701255

  • RE: Log file is filling up

    Thank you so much guys for helping me out here. There is 1 more question I have. I can start a new thread but it is regarding the Tlog so...

    March 28, 2014 at 11:18 am

    #1701240

  • RE: Log file is filling up

    JoshDBGuy (3/28/2014)

    Initial log file size is 121 MB and the autogrowth is 10 percent which currently equates to about 12 MB. Where do you see 30 GB?

    I am sorry, what...

    March 28, 2014 at 10:47 am

    #1701218

  • RE: Log file is filling up

    samalex (3/28/2014)

    One issue is the potential of one log or data file filling up the entire drive preventing the other data and log files from growing.

    We already created...

    March 28, 2014 at 9:41 am

    #1701192

  • RE: Log file is filling up

    JoshDBGuy (3/28/2014)

    New Born DBA (3/28/2014)

    Please see the attachment.

    That's actually two terabytes. That's your maximum file size, not the autogrowth amount. 10% is the amount your log file currently grows. If...

    March 28, 2014 at 9:36 am

    #1701190

  • RE: Log file is filling up

    The initial size is 121 and it is also set to auto-grow by 10%, restricted growth to 2097152MB which is not 30GB (My bad)

    March 28, 2014 at 9:21 am

    #1701181

  • RE: Log file is filling up

    Jeff Moden (3/28/2014)

    New Born DBA (3/28/2014)

    Come to think of it, I don't know how adding initial size to 1000 MB and set the growth to 1000 MB will help. The...

    March 28, 2014 at 9:18 am

    #1701177

  • RE: Log file is filling up

    JoshDBGuy (3/28/2014)

    Also, I forgot to mention in my above post, in the future you should think about putting your log and data files on separate drives. Both files placed on...

    March 28, 2014 at 9:03 am

    #1701163

  • RE: Log file is filling up

    Come to think of it, I don't know how adding initial size to 1000 MB and set the growth to 1000 MB will help. The auto-growth of the log file...

    March 28, 2014 at 8:50 am

    #1701151

  • RE: Log file is filling up

    I think we are a little bit stingy when it comes down to giving extra space to the log file. Lesson learned.

    1 more question. When the log file gets filled,...

    March 28, 2014 at 8:48 am

    #1701150

  • RE: Log file is filling up

    See the attachment.

    March 28, 2014 at 8:24 am

    #1701130

Viewing 15 posts - 226 through 240 (of 309 total)