Viewing 15 posts - 421 through 435 (of 479 total)
Hi all
Talking briefly on raid 0+1, anyone have comments on placing all data,log,etc files onto the single fat raid0+1 array?? here I am talking a minimum of 8 drives....
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
November 12, 2001 at 3:09 am
Hi guys
Another option (will try today), is to save as a VB package and allow users to alter via VB, its messy though.
In the end its fair enough...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
November 6, 2001 at 6:59 pm
Andy
Hi Andy, well Im not sure about this article and its validity in some areas.
My only real concern in the title of the article, I believe that is not...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 21, 2001 at 11:29 pm
Good article steve. Perhaps worth while mentioning how you can load up sql*server tables from the results of a external command being executed? I cant remember the exact...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 17, 2001 at 1:06 pm
Hi there
Yes, I agree and learnt the hard way. This is a real gotcha when your an oracle DBA moving into the SQLServer realm. Basically I now take...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 14, 2001 at 10:52 pm
well still cant find the fix, but this command is fantastic! :
DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 10, 2001 at 2:51 am
Right on the money Andy.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 9, 2001 at 7:16 am
More info:
a) Server is running NT 4 SP5
b) RAM installed is (not including base dimm)
4x64Mb (banks 1&2)
4x128Mb (banks 3&4)
4x256Mb (banks 5&6)
c) Tried to bump up swap files to 2gig from...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 5, 2001 at 3:20 am
Hi
It all comes down to
a) what your comfortable with
b) where your teams expertise lies, ie. ongoing maintenance
c) simplicity
id go for sp's as Im not a...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 20, 2001 at 7:12 pm
Hi
Im not 100% sure on this, but check perfmon out, from memory you can set an event to throw an email or netsend message when the instance is down. ...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 20, 2001 at 7:09 pm
Hi all
Some more info I got from a training CD. I have yet to confirm this..
SQL*Server - v7.x
User(connect) 24Kb
Open DB 2880...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 13, 2001 at 7:43 am
Hi
Ive been meaning to post my backup script that does what you asked for. I use xp_cmdshell and do a call out to a small EXE file I use...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 10, 2001 at 7:33 pm
Hi
Crank out perfmon and start adding counters. Run this for a few hours every minute. You will be amazed how much information this can give you.
80 concurrent users...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 6, 2001 at 6:10 pm
No probs Andy.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 6, 2001 at 12:48 am
Hi there
I have been running this combo for around 8 months todate. No issues what so ever and I have yet to come accross any problems with performance from...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 4, 2001 at 11:15 pm
Viewing 15 posts - 421 through 435 (of 479 total)