Viewing 15 posts - 871 through 885 (of 1,319 total)
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...
October 31, 2008 at 8:42 am
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...
October 31, 2008 at 8:20 am
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...
October 31, 2008 at 8:03 am
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...
October 31, 2008 at 7:41 am
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...
October 31, 2008 at 7:38 am
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...
October 31, 2008 at 7:24 am
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...
October 31, 2008 at 7:09 am
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...
October 31, 2008 at 6:56 am
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...
October 29, 2008 at 2:12 pm
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...
October 20, 2008 at 11:48 am
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...
October 17, 2008 at 1:53 pm
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...
October 16, 2008 at 3:12 pm
Jack Corbett (10/16/2008)
SQL 7, 2000 I used xp_smtp_sendmail. I would post a link,...
October 16, 2008 at 2:13 pm
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...
October 9, 2008 at 6:16 am
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...
October 8, 2008 at 3:05 pm
Viewing 15 posts - 871 through 885 (of 1,319 total)