Viewing 15 posts - 91 through 105 (of 219 total)
I've always had a problem with the hard 80% threshold, especially when applied to backup drives.
In your situation, I would cycle the SQL logs daily, keep a few days. ...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 11:16 am
Personally, I would still prefer to have more disks in production. Let's say you SAN team will give you 32 total disks. I'd rather have 24 in prod...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 10:48 am
Maninder S. (4/30/2010)
Yes Large files are not a issue. but sometimes the policies across departments, lead us into a tight position.Thanks
Then what's the question? SQL is defaulted to keep...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 10:44 am
Write a cursor.
Fetch each county into it.
Create a variable and keep concat'ing the new county + a space
When the cursor is done, print the variable that contains the string with...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 10:32 am
CirquedeSQLeil (4/30/2010)
GregoryF (4/30/2010)
I often wonder if the...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 10:28 am
rbowers 18291 (4/30/2010)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 10:19 am
I've also seen this behavior with Websense, and currently, we have a finincial compliance/disclosure 3rd party app that creates a new DB every day.
I often wonder if the people who...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 10:15 am
The maintenance plan adds a unique time stamp to each T-Log dump in the file name
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 9:01 am
Because log shipping fills up our logs quickly we have a job to roll the error log nightly, my usual policy is to keep 32 or 64 logs.
Large logs are...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 8:51 am
The closest thing in SQL would be geo-clustering which offers multi-datacentre redendancy in a combined HA/DR solution. But it certainly does not offer load balancing. And geo-clustering is...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 7:30 am
I have seen many servers with a "blank state". These are usually SQL2000 servers in a clustered environment. Microsoft has never gotten those to appear *** running/stopped in...
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 6:49 am
Our's is on a VM server. I trust the NT group enough that they have built in sufficient redundancy (the VM server that VMWare sit's on is virtually clustered)....
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 29, 2010 at 5:50 pm
Dugi (4/29/2010)
GilaMonster (4/29/2010)
Lowell (4/29/2010)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 29, 2010 at 4:33 pm
Lowell (4/29/2010)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 29, 2010 at 1:53 pm
Our NT group monitor's the status of services. If a service enters the stopped status, we are alerted.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 29, 2010 at 11:43 am
Viewing 15 posts - 91 through 105 (of 219 total)