Forum Replies Created

Viewing 15 posts - 211 through 225 (of 2,436 total)

  • RE: Unable to start SQL jobs remotely

    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."

  • RE: job failed

    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."

  • RE: SQL 2005 Maintenance Plan Rebuild Index Error

    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."

  • RE: Nic Teaming

    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."

  • RE: Nic Teaming

    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."

  • RE: Nic Teaming

    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."

  • RE: How fast is RAID-5

    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."

  • RE: Separate Forum for I want to be a DBA topics

    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."

  • RE: bcp - Importing Non Native Data

    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."

  • RE: installing SQL SERVER2005 SP3 On production.

    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."

  • RE: NetBackup MS SQL Client

    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."

  • RE: Squeezing the DBA

    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."

  • RE: Data Types

    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."

  • RE: Possible ? Sybase 15 Publisher & MS SQL 2005 Subscriber

    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."

  • RE: SQL server Error log rotation

    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."

Viewing 15 posts - 211 through 225 (of 2,436 total)