Forum Replies Created

Viewing 15 posts - 6,796 through 6,810 (of 9,253 total)

  • RE: Migrating standalone instance to cluster and new SAN

    Colleen M. Morrow (8/1/2011)

    Any problems overwriting clustered system databases with non-clustered master?

    never tried it but cant see why it wouldnt work. Most of the cluster info is held in the...

    August 22, 2011 at 4:03 am

    #1371312

  • RE: Which failover method is better?

    Loner (8/20/2011)

    I need to create a warm standby.

    Do the standby databases need to be readable or are they purely standby? What are you trying to achieve here, DR or a...

    August 21, 2011 at 5:09 pm

    #1371226

  • RE: SQL Server 2008 Install fails at the last stage

    Perry Whittle (8/16/2011)

    have you verified that the new disk resources you intend to use for the new instance online and offline properly through the cluster management console?

    Also check the new...

    August 19, 2011 at 10:07 am

    #1370874

  • RE: Applying SQL 2008 R2 SP1

    morrisos (8/17/2011)

    Hopefully and easy one here.

    What is best procedure to apply sp1 to a 2-node active\passive cluster? I already applied on active node. Do I failover...

    August 18, 2011 at 2:49 am

    #1369984

  • RE: If you could use xp_CmdShell securely, would you?

    Jeff Moden (8/17/2011)

    Well done on vetoing SA privs for webstie connections, Perry. I hope your "veto" actually stuck. I've seen many a DBA team get overridden by a...

    August 18, 2011 at 2:21 am

    #1369973

  • RE: Physical CPU or Logical Processors ?

    awu (8/17/2011)

    it's saying max numbers of CPUs the SQL Server 2008 R2 Standard edition support is 4, is that mean i should set the number less than 4 ?...

    August 18, 2011 at 1:14 am

    #1369962

  • RE: Physical CPU or Logical Processors ?

    Oracle licence per core and get away with it, shouldn't think it will be long before MS capitalise on it too

    August 17, 2011 at 2:24 pm

    #1369852

  • RE: Need advise on backup huge monster DB

    Michael Valentine Jones (8/17/2011)

    You should consider moving to SQL Server 2008 (or R2) Enterprise Edition

    given the costs it may just be worth spending the few hundred dollars on a licence...

    August 17, 2011 at 1:23 pm

    #1369811

  • RE: Need advise on backup huge monster DB

    Grant Fritchey (8/17/2011)

    I know just the tool for the job...

    😀 hmm, let me think now i wonder what it could be 😉

    August 17, 2011 at 1:20 pm

    #1369810

  • RE: Moving Server to a new domain

    sql server user accounts won't be affected but windows accounts including any service accounts may need to be addressed

    August 17, 2011 at 10:34 am

    #1369733

  • RE: Need advise on backup huge monster DB

    Steve Jones - SSC Editor (8/16/2011)

    Best advice, use backup compression first. If you have Enterprise Edition, you can use that

    not available in SQL Server 2005, you will need a 3rd...

    August 17, 2011 at 10:32 am

    #1369729

  • RE: If you could use xp_CmdShell securely, would you?

    Jeff Moden (8/17/2011)

    Perry Whittle (8/17/2011)

    Its always been given bad press in the past due to the vulnerability. Its a feature hackers knew was there and could be exploited to harmful...

    August 17, 2011 at 9:56 am

    #1369709

  • RE: Mirroring in High Safety Mode (?)

    DBAgal (8/17/2011)

    So, if the mirror database is offline and can't acknowledge the transaction right away, the transactions just continue to queue up until the mirror database becomes available? The...

    August 17, 2011 at 8:44 am

    #1369649

  • RE: Mirroring in High Safety Mode (?)

    Loss of the mirror

    If the mirror fails, the principal continues functioning, but the mirroring state is

    DISCONNECTED and the principal is running exposed. Once the mirror database

    becomes operational, it automatically assumes...

    August 17, 2011 at 7:57 am

    #1369604

  • RE: Log File not clearing

    Andrew Theodore (8/16/2011)

    Just so everyone knows, restarting a second time allowed the DB to be shrank. Not sure why it didn't happen with the first reboot.

    would of been handy to...

    August 17, 2011 at 1:42 am

    #1369452

Viewing 15 posts - 6,796 through 6,810 (of 9,253 total)