Forum Replies Created

Viewing 15 posts - 2,491 through 2,505 (of 9,244 total)

  • RE: login transfer in dbmirroring

    RUNNERSQL (1/24/2015)


    i have created a new login in principle server and provided dbowner permission to principle db.

    how do i transfer this login to mirror server and assign the same permission...

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

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

  • RE: 3rd party tools for backup compression

    which edition\version of sql server are you using?

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

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

  • RE: EMC Migration and Cluster

    done this before a few times, i have used a new cluster with its own storage and mighrated databases between clusters.

    Leaves a you a rollback scenario in place

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

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

  • RE: Partitioning: Maximum of 1000 partitions reached

    also read the doc at the following link

    https://msdn.microsoft.com/en-us/library/gg981694.aspx

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

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

  • RE: Partitioning: Maximum of 1000 partitions reached

    there is a patch to enable 15000 partitions what is your exact sql server edition\version?

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    johnnyrmtl (1/25/2015)


    K great... Although I do have to install this FCI tomorrow and wanted to understand it as much as possible by then as to not start it over.

    Any draft...

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    yes level 5 is to be published on 11th feb

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    Levels 1 to 4 detail the requirements for a windows server failover cluster, this forms the basis of either an FCI or an AlwaysOn Availability group setup.

    Level 5 details FCIs...

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    johnnyrmtl (1/24/2015)


    I am somewhat confused as the guide for an " AlwaysOn Failover Cluster Instance" mentions the creation of "Availability groups".

    If my application is constantly creating new databases, do I...

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

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

  • RE: Netbackup Restore - Encrypted Database

    the cert should only require creating once, is this a backup of the same database or another?

    Has the cert changed on the source server maybe and now doesn't match the...

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

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

  • RE: SQL SERVER + SSD

    chucking in SSDs will just probably mask the real issue. SSDs are indeed faster than traditional disks but even they have a limit.

    It's been said already, code and database design...

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    see my stairway series on this site starting at this link[/url]

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    johnnyrmtl (1/21/2015)


    That is indeed my dilemma as new databases will be added continuously to the instance 🙁

    What would be the best solution ?

    What is it you're looking to achieve, high...

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

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

  • RE: physical nodes and VMs -windows cluster

    check everything, the networking between the nodes, the networking between the domain controller and the node, also the permission level of the user running the add node operation

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

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

  • RE: physical nodes and VMs -windows cluster

    check the windows event log and the cluster events too

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

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

Viewing 15 posts - 2,491 through 2,505 (of 9,244 total)