Viewing 15 posts - 1 through 15 (of 18 total)
I'd like to give this ApexSQL Log a try but I'm not sure how now we are after the event.
What I have left to analyse is a BAK...
May 22, 2008 at 10:52 am
Mr Guru, I would have to disagree. Our website code-base is vast, spans two technologies and some of it dates back 8 years (hence not-so-well-written). If I...
May 22, 2008 at 5:40 am
This is a SQL 2000 not 2005 server.
May 21, 2008 at 2:39 pm
This is exactly the type of attack being attempted. We can't see any confirmation of it having been successful in the database though. My developers have been checking...
May 21, 2008 at 1:57 pm
This may or may not be related to the translog filling but we have found through our investigation some SQL injection attacks attempts on the db.
The injection attack is using...
May 20, 2008 at 7:05 am
TheSQLGuru (4/14/2008)
1) 2 cpus (unless they are dual or quad core (NOT Hyperthreaded)) is a bit light to process that much RAM.
Yep, we are going with 2.4Ghz quad core Xeon's
2)...
April 14, 2008 at 1:03 pm
TheSQLGuru (4/14/2008)
2) This server could well be numa-enabled. There is a LOT of mess that comes into play with that. Deep stuff.
Geeeez.
Can you recommend any white...
April 14, 2008 at 10:48 am
TheSQLGuru (4/14/2008)1) I wasn't aware there was a SP4 for Win2k3
... I was time travelling. Make that SP2!!
3) 64bit code would mean no AWE and no PAE and no...
April 14, 2008 at 10:22 am
EdVassie (4/14/2008)
The obviouis question to ask as you are using a 64-GB box, is why are you not using 64-bit OS and 64-bit SQL. Memory management would be far...
April 14, 2008 at 3:11 am
GilaMonster (4/4/2008)The users will be transfered as part of the mirroring (since they're DB objects)
Of course, duh! I didn't think of that. So basically as long as when changes...
April 4, 2008 at 7:32 am
AndyD (4/2/2008)
For Logins, my advice is to stick with Windows Authentication only. That way, all logins are via domain users/groups - no logins need to be transferred.
True, but you still...
April 3, 2008 at 4:23 am
ALTER DATABASE yourDBName SET PARTNER OFF
will break the mirror. You can run this command on either the ServerA or ServerB (Principal or Mirror).
You'll then be left with the Mirror...
April 2, 2008 at 3:21 am
I had this in my script but didn't realise it was killing connections! A re-read of BOL I can see now it's the WITH ROLLBACK IMMEDIATE is termination information...
March 20, 2008 at 5:17 am
Nick,
I've been looking into C2 Auditing because we need to set up this level of audit logging for PCI Compliance. There is a good article on this site which...
March 19, 2008 at 8:01 am
Thanks guys (and girls) for all the tips. I have the VERIFYONLY being run as part of the daily backup (now I know in 2005 this is actually worth...
March 17, 2008 at 7:28 am
Viewing 15 posts - 1 through 15 (of 18 total)