Forum Replies Created

Viewing 15 posts - 526 through 540 (of 860 total)

  • RE: Full Transaction log

    jfoster (3/18/2009)

    Krishna,

    I thought I'd post another alternative which I didn't see in your article. I've used this in the past, with good results. This method allows me to...

    March 18, 2009 at 5:43 pm

    #962366

  • RE: Full Transaction log

    GilaMonster (3/18/2009)

    Your first suggestion for a full tran log is to shrink it. Maybe I'm missing something, but that's completely the opposite of what's needed.

    The log is full, ie, there...

    March 18, 2009 at 5:37 pm

    #962365

  • RE: Full Transaction log

    GilaMonster (3/18/2009)

    Your first suggestion for a full tran log is to shrink it. Maybe I'm missing something, but that's completely the opposite of what's needed.

    The log is full, ie, there...

    March 18, 2009 at 5:36 pm

    #962363

  • RE: Full Transaction log

    Sorry guys I have missed all the banter 🙂 I was a little busy at work today. I will join the discussion.

    March 18, 2009 at 5:27 pm

    #962361

  • RE: How to Know how much memory is occupies for sqlserver software

    Also, remember SQL server choses memory dynamically. Did you specify any Min. and Max. setting?

    March 18, 2009 at 6:23 am

    #961768

  • RE: Steps to take by fresher in DBA field?

    venu_ksheerasagaram (3/18/2009)

    Hi All,

    I am new to this DBA field, Can you please suggest me any topics and hands on to work...

    March 18, 2009 at 6:20 am

    #961764

  • RE: Database Mirroring

    vijaishankar.yadav (3/18/2009)

    How to Mirror DB from One Server to Other

    Its a simple setup with GUI, but you need to know a lot before implementing on your production. Start with BOL...

    March 18, 2009 at 6:17 am

    #961763

  • RE: Full Transaction log

    michael_sawyer (3/18/2009)

    I cannot believe that backup was the third option. The first and best option is to create proper maintenance on the database. The only transactions you need...

    March 18, 2009 at 6:06 am

    #961750

  • RE: Full Transaction log

    jts_2003 (3/18/2009)

    Hi Krishna

    Very clear article, but I was a bit confused about the first option of shrinking the log - if it is full now, won't shrinkign the physical size...

    March 18, 2009 at 4:47 am

    #961706

  • RE: Full Transaction log

    Tom Walters (3/17/2009)

    Krishna - Good article. Question though. What if the logfile expanded to fill the rest of the drive. Then what?

    hi Tom,

    Thanks for your feedback. if the log file...

    March 18, 2009 at 4:42 am

    #961701

  • RE: Regarding LDF file.

    swmsan (3/16/2009)

    Thanks...

    But the problem is that there's no space now. Hence manager asked me to reduce the log size..pls guide what to do now..?

    shall I truncate it ..?

    You can definitely...

    March 17, 2009 at 5:22 pm

    #961497

  • RE: MS SQL queue

    sys.dm_os_waiting_stats dynamic managemtn view should be able to show you information about the wait queue stats.

    March 17, 2009 at 5:18 pm

    #961492

  • RE: Index not rebuilding

    Joseph (3/17/2009)

    so that means all these three factors should be true together i mean :-

    avg_fragment_size_in_pages >= 8 AND fragmentation > 10 AND page_count >=1000

    please correct me If i am wrong?

    Yepp,...

    March 17, 2009 at 4:19 pm

    #961467

  • RE: Index not rebuilding

    Joseph (3/17/2009)

    Hi Gail,

    quick question - I have the doubt.. so you said indexes having 1000 pages or more than that should only be considered..

    along with this, dont we have to...

    March 17, 2009 at 3:55 pm

    #961450

  • RE: Log Shipping

    1.) If your Primary Database is accessible, backup the last portion of the log WITH NO_RECOVERY which makes to stall any updates to primary database.

    2.) Copy over the uncopied tlogs...

    March 17, 2009 at 3:25 pm

    #961426

Viewing 15 posts - 526 through 540 (of 860 total)