Forum Replies Created

Viewing 15 posts - 4,051 through 4,065 (of 9,244 total)

  • RE: 2012 and Always on - different security access?

    khott (7/3/2013)


    Here is what I would like to do and wanted to know if possible.

    With always on, have one active node for production applications, one node for reporting with different...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Windows active directory upgrade impact on Windows SQL cluster?

    davidwarner (7/2/2013)


    The DNS names of the servers will change.

    Are you referring to the node computernames?

    What do you mean DNS names will change?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Windows active directory upgrade impact on Windows SQL cluster?

    as long as you have access to a DNS server and a domain controller it shouldn't make any difference to you.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: change dbo login name

    HildaJ (7/1/2013)


    I have a database that I need to change the dbo owner from user A to user B. I'm getting different errors.

    When I try to change it I...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SAN LUNs and disk striping

    You're carving LUNs from the same set of physical disks, which is not best for performance. Having said that, it depends on how the cache is configured and how good...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL SERVER 2008 Cluster Failover message

    kjtyson05 (6/21/2013)


    Thanks so much for all the info and thank you Perry for the great article. Very nice piece of work!

    Thanks,

    Kevin

    Glad you found it helpful 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL SERVER 2008 Cluster Failover message

    george sibbald (6/21/2013)


    thanks Perry I thought you would have relevant links to hand.

    but i still get my point 🙂

    😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL SERVER 2008 Cluster Failover message

    kjtyson05 (6/21/2013)


    What I had to do was place a dependency on the mount point that the disk arrays that hold "data, backup and tempdb" are online before the mount point...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL SERVER 2008 Cluster Failover message

    See my article here[/url] and also the relevant Microsoft KB

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Clustering and VMware

    I have P2V'd machines that had SAN attached storage no problem in the past. There were issues with earlier versions of VMware converter where it wouldn't see SAN attached drives...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL SERVER 2008 Cluster Failover message

    As George said have you checked the resource dependencies in the cluster group\application?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Can mirroring be set up with a copy only backup?

    you could take a diff and use the 6 day old full with logs

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Restoring from the backup after encryption of datbase

    Learner44 (6/19/2013)


    open MASTER KEY DECRYPTION BY PASSWORD = 'password';

    RESTORE DATABASE Encry2

    FROM DISK = N'D:\SQL2008R2DB\MSSQL10_50.SQL2008R2\MSSQL\Backup\TDEPost.bak'

    WITH FILE = 1,

    MOVE N'mydb' TO N'D:\SQL2008R2DB\MSSQL10_50.SQL2008R2\MSSQL\Backup\TDEPost.mdf',

    ...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: service pack on cluster

    Elliott Whitlow (6/19/2013)


    It is my understanding that the system databases get upgraded when SQL starts for the first time with the new (updated) binaries. It can tell internally that...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: IP Address Doesnt turn from offline to online

    With the clustered ip resource offline try an RDP connection to the IP address 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 4,051 through 4,065 (of 9,244 total)