Viewing 15 posts - 211 through 225 (of 2,436 total)
Have you tried changing out the RAM back to the original chips and see if the problem still occurs ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 10, 2009 at 9:17 am
Some things to check:
Is your SQL Server running under a 'named' account or LocalSystem ?
Is NT Authority\System in the sysadmin role ?
Have you removed BuiltIn\Administrators ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 10, 2009 at 9:14 am
Does the table that the index references have any computed columns ? If so this is a known issue.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 10, 2009 at 9:12 am
Resources are registered in the Cluster Administrator as well as dependencies.
Dependent on the resource type checks are performed at various times. When things do not 'check out' a failover is...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 2:53 pm
Think about it - a cluster is for high availability - if a resource fails the virtual node is moved. Add into that NIC Teaming, which in and of itself...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 1:38 pm
I have used NIC teaming alot on HP and IBM hardware in the past - the benefit is in not losing network availabilty - the teaming software just fails over...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 12:51 pm
9 Mb/second = 540 Mb/minute ... Hmmm ...
In theory, dual channel, dual path 4 Gb fiber cards, puts you at a theoretical maximum of a about 1.8 Gb/minute thoughput each...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 12:47 pm
Please add to the list:
recover modes - simple|bulk-logged|full
transaction log backups
why not to shrink your database
why not to shrink your transaction log
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 12:38 pm
bcp was designed to be quick and simple. It works extremely well if all the data in in character format - the default.
I have used it to bring in...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 12:32 pm
The most important advice that I can give, after you do you homework first, is try it on a test server !
I cannot stress enought 'testing' the process on another...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 12:25 pm
Briefly ...
1 --> This depends how large your databases are and how much data you keep online - unless you go to tape directly.
2 --> SQL server is designed to...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 12:22 pm
I have actually been in this 'situation' twice in my career. The first time working for a CLEC in 2000. A VP asked for some financial data to be 'modified'...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 11:18 am
VS COBOL, VS COBOL I, VS COBOL II along with IMS and DB2 ...
all so long ago (after BAL) back in the early and mid eighties ...
age and senility are...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 2, 2009 at 1:21 pm
I dunno - way back when (the late 80's ) I supported a system that:
Replicated DB2 to Sybase with Sybase 'pulling'
then
Sybase to SQL Server with Sybase 'pushing'
then
SQL Server to many...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 2, 2009 at 11:50 am
Another approach is just to set up a scheduled task to perform this weekly.
This works well if you configure the number of SLQ Server errorlogs to 99.
We just use the...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 2, 2009 at 11:38 am
Viewing 15 posts - 211 through 225 (of 2,436 total)