Forum Replies Created

Viewing 15 posts - 871 through 885 (of 1,319 total)

  • RE: Transaction Log Free space

    Just to add a little to Gail's last post, and this is not meant as a putdown - if there is no other "more senior" DBA on staff, seek some...

    -- You can't be late until you show up.

  • RE: Transaction Log Free space

    The only way for anyone to help is to know what issues your are facing. Nobody here knows your environment so if you are having problems, detail them and someone...

    -- You can't be late until you show up.

  • RE: Red Gate SQL Backup vs. Quest Lite Speed backup

    WooHoo - maybe I'm not as far gone as, she - what was her name again? - oh yeah, the wife, thinks I am. Thanks for the reminder.

    Edit - In...

    -- You can't be late until you show up.

  • RE: Red Gate SQL Backup vs. Quest Lite Speed backup

    I knew it was one of them. I've used all three products at various points of my career. All good products where the decision was usually made based on costs...

    -- You can't be late until you show up.

  • RE: Error message:Microsoft Cursor Engine Ox8007010B

    Try searching with "Microsoft Cursor Engine 0x8007010B" (it's 0x not Ox).

    There are alos a couple of pdf files that may provide help. It seems you cannot find a directory name...

    -- You can't be late until you show up.

  • RE: Red Gate SQL Backup vs. Quest Lite Speed backup

    Just my 2 cents - either the Idera or RedGate product (I want to say Idera but the memory isn't what it used to be!) did not require a license...

    -- You can't be late until you show up.

  • RE: Regarding Log backups???

    If you're using maintenace plans (and I know some folks detest them!!), you can automate the cleanup process, so from a maintenance perspective, there really isn't much to do. From...

    -- You can't be late until you show up.

  • RE: Transaction Log Free space

    Lynn Pettis (10/29/2008)


    I'd set the autogrowth to a fixed amount, not a percentage.

    I couldn't agree more. This applies to both log and data files, IMO. A 120 MB seems awful...

    -- You can't be late until you show up.

  • RE: Looking for reviews please!

    nunYoBidnez (10/24/2008)


    Editor's Note: This post has been removed as it was not deemed appropriate.

    Thanks Steve. When I read it, I didn't think so either (meant to drop you a note...

    -- You can't be late until you show up.

  • RE: Database Disaster Recovery

    Typically, backup to separate physical disks on the same server. Place log and databases files on separate physical drives as well. Having mirroring or raid for hot swappable drives is...

    -- You can't be late until you show up.

  • RE: Database Health Checks

    Since nobody has replied, I'll give you my 2 cents and see if others have a better idea. I only have 15 servers so not quite the same situtation but....Create...

    -- You can't be late until you show up.

  • RE: Setup Email alart On Server

    The text file was a sql file (I changed the extension to upload it). Go to the website and download the zip file. You'll get the text file I attached...

    -- You can't be late until you show up.

  • RE: Setup Email alart On Server

    Jack Corbett (10/16/2008)


    Yes, to use xp_sendmail you need Outlook installed on the SQL Server. When I was using

    SQL 7, 2000 I used xp_smtp_sendmail. I would post a link,...

    -- You can't be late until you show up.

  • RE: best backup Strategy

    Jack Corbett (10/8/2008)


    Better to backup too much than not enough.

    Amen to that. How many times have we seen "I have corruption but no backup"? Or "my data is gone and...

    -- You can't be late until you show up.

  • RE: Backup takes too long?

    At my prior job, we used litespeed to backup a 250Gb database to a remote location and it only took 40 minutes. I'd have the network folks look at the...

    -- You can't be late until you show up.

Viewing 15 posts - 871 through 885 (of 1,319 total)