Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 2,436 total)

  • RE: suspect database issue

    You have one viable courses of action available that I can think of.

    Restore from the last clean backup - yes data loss will occur but there will be no corruption...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Database File Size Even Distribution

    Yes. Exactly.

    G: drive --> Meta-LUN for database data, striped across 3 LUNs

    H: drive --> Meta-LUN for transaction logs. striped across 5 LUNs

    I: drive --> Meta-LUN for database backups, striped...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: 5000 posts....new contest

    As remember from my youth, the only 'certainty-s' were: Death and Taxes.

    Now the information age has added another 'certainty': The computer will crash !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: SQL Network Name in cluster

    Failover has various phases: IP address, storage, services then SQL Server startup. In a Win 2K3/SP1 w/SQL 2K/SP3, I can see a complete 'failover' taking 3-5 minutes. Our clusters generally are...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: RE:

    here's a website you'll probably bookmark: http://www.connectionstrings.com/

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Sa Password

    One 'biggie' commonly missed is also the JOBs that the SQL agent executes. DTS and bcp also come to mind ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: 5000 posts....new contest

    death is not a constant, it is a state, a change in the state of existance ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: BCP and encrypted password

    SQL Server service account should not be LocalSystem nore local computer accounts. They need to be domain user acconuts that are in the LocalAdministrators security group. As an additional security...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: security question - what role is appropriate for my boss?

    In order to monitor things (what you are doing and more importantly what is going on) you have no choice but to make him a sysadmin <period>. After all your...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Connection to SQL server 2000

    Integrated security should work if, and I say if, the user logs into the domain via 'normal' means. In other words either your VPN has hooks into AD or the...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: 5000 posts....new contest

    Change is the only constant of existance ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: SQL Network Name in cluster

    I do not know if adding WINs would make a difference. We use DNS and WINs as standards here.

     

    How much time are you talking abut having to wait anyway ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Page Faults/sec Counter

    If this is a scalability test then should't you be using quad CPUs and 4 Gb of RAM ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: SQL server 2000 setup error message???

    All is well. Just continue and apply the service pack after the initial installation reboot. Here's the KB link:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;329329

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: delete large number of rows

    Excellent points Philip. I'd forgotten about some of those hidden 'nasties' lurking in DRI ...

    (I've got to review SQL 201 again !!!)

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 1,891 through 1,905 (of 2,436 total)