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 ?

  • 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 ?

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

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

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

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

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

  • 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

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

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

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

  • 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'...

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

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

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

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