Forum Replies Created

Viewing 15 posts - 31 through 45 (of 66 total)

  • RE: Is our log file too big?

    Grant Fritchey (8/31/2010)

    Wait, wait, wait!

    If it's a production server, putting it into Simple could be a huge problem. What's the recovery SLA? If they're expected to be able to get...

    August 31, 2010 at 7:02 am

    #1214237

  • RE: Is our log file too big?

    Grant Fritchey (8/31/2010)

    The think about backing up the drive is, SQL Server maintains locks on the files. They're not getting backed up. You'll need to create a backup process that...

    August 31, 2010 at 6:46 am

    #1214215

  • RE: Is our log file too big?

    Ramji29 (8/31/2010)

    GilaMonster (8/31/2010)

    DB I used to work with had a 250GB log file. Make sure that you're maintaining it correctly and don't worry too much.

    Managing Transaction Logs[/url]

    Thx Gail for correction......

    August 31, 2010 at 6:35 am

    #1214208

  • RE: Is our log file too big?

    GilaMonster (8/31/2010)

    So read through the article I referenced, check what you are and are not doing and post back if you want to clarify more things.

    Thanks Gail, I'm looking at...

    August 31, 2010 at 6:29 am

    #1214201

  • RE: Is our log file too big?

    GilaMonster (8/31/2010)

    DB I used to work with had a 250GB log file. Make sure that you're maintaining it correctly and don't worry too much.

    Managing Transaction Logs[/url]

    And therein lies the problem...

    August 31, 2010 at 6:19 am

    #1214189

  • RE: Is our log file too big?

    Ramji29 (8/31/2010)

    Matt... size of log file depends on the size of the data file (mdf) and as per my experience this shud be generally between 20% to 40% of the...

    August 31, 2010 at 6:10 am

    #1214179

  • RE: sql server logfile

    Thaks Gail, I'll check it out

    May 22, 2010 at 2:20 pm

    #1171250

  • RE: Unable to restore from backup

    Rajesh M S (12/31/2009)

    hmmm

    Some times in these cases Continue_After_Error option will be work.

    Basically database restore process will continue when we use Continue_After_Restore it instucts backup to continue despite of encountering...

    January 4, 2010 at 1:54 am

    #1098305

  • RE: Unable to restore from backup

    homebrew01 (12/31/2009)

    Do you not have transaction log backups that could be applied to your week-old full backup ?

    One of the problems was that the log files were changed to a...

    January 4, 2010 at 1:52 am

    #1098304

  • RE: Unable to restore from backup

    GilaMonster (12/29/2009)

    Looks like you're trying to restore over the existing database. Don't. Drop the corrupt database and restore the new one from scratch.

    Post the restore command that you're using.

    Do you...

    December 30, 2009 at 2:27 am

    #1097356

  • RE: Unable to restore from backup

    yes

    December 28, 2009 at 2:43 pm

    #1096835

  • RE: How do I tell which indexes are not being used

    Thakyou all for your useful suggestions, I shouldn'y have any problems now 😉

    August 11, 2009 at 1:40 am

    #1037273

  • RE: Execution plan

    GilaMonster (7/8/2009)

    Matt, any reason for the TOP (100) PERCENT?

    No reason, why, could it be causing a problem? I think originally I did the query in as a view and the...

    July 8, 2009 at 9:29 am

    #1021793

  • RE: Execution plan

    GilaMonster (7/8/2009)

    That means that those particular operators are running in parallel.

    Thanks Gail, is that an issue that I need to worry about or is it a normal situation

    July 8, 2009 at 3:02 am

    #1021534

  • RE: Does this query look okay?

    Thanks GSquared

    I'll give it a go and see which way is the most efficient

    April 30, 2009 at 2:13 am

    #986486

Viewing 15 posts - 31 through 45 (of 66 total)