Forum Replies Created

Viewing 15 posts - 3,946 through 3,960 (of 9,244 total)

  • RE: Add additional SQL 2012 instance to Windows Failover Cluster

    dgraf (9/20/2013)


    Hi All,

    I have a Windows Failover Cluster setup across 3 nodes with only 1 service/application running on it - which is SQL Server 2012. Everything works great, however now...

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

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

  • RE: litespeed backup consumes high cpu

    the default within Litespeed is to parallelise across all available CPUs. Using the @affinity and @throttle parameters you are able to specify which processors the backup uses and the max...

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

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

  • RE: Question on certificate and asymmetric logins

    database mirroring between stand alone servers.

    Certs are also used for TDE

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

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

  • RE: "Could not find a log backup file that could be applied to secondary database"

    sickpup (9/17/2013)


    Hello all,

    I'm running into some trouble setting up log shipping (on a 2008 R2 installation) and I'm hoping someone can point me in the right direction.

    I'm using the setup...

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

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

  • RE: How to find cause of failover in clustering?

    Yes you have to create a new query

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

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

  • RE: How to find cause of failover in clustering?

    Open fail over cluster manager and view cluster events there

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

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

  • RE: How to find cause of failover in clustering?

    refer to the cluster events console and the app and sys event logs for more info

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

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

  • RE: Copy File Across Servers Failing

    homebrew01 (9/16/2013)


    I have 2 servers that are in the same rack, but not on a domain. Ultimately, I want a SQL scheduled job to copy files from Server_A to Server_B

    Logged...

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

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

  • RE: Adding a Node to a cluster SQL Server 2008 R2

    ft55 (9/9/2013)


    The steps i was considering are :

    1. Infrastructure team build new server and add the new node to the failover cluster at a windows level.

    2. Run the Add node...

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

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

  • RE: Need to delete backup files which are restored on secondary database

    use the following to purge backup files from the secondary

    exec sys.sp_change_log_shipping_secondary_primary

    @primary_server='primary sql instance'

    , @primary_database='primary db name'

    , @file_retention_period = no_of_minutes_to_keep

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

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

  • RE: SQL Server 2012 cluster install error

    Brad Feaker-195979 (6/11/2013)


    I am installing SQL Server 2012 Enterprise (x64) with SP1 on a Windows 2012 SP1 3 node cluster utilizing mount points.

    I get the following error during the...

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

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

  • RE: Minimum Active Directory required for SQL Server 2012 Enterprise

    Fal (9/3/2013)


    I have had a request from our Network Admin as to "what is the minimum level of Active Directory required for SQL 2012?"

    Note that I am not asking for...

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

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

  • RE: MS cluster pre-setup question

    sqldba725 (9/4/2013)


    For any MS cluster setup Active /Passive do I need Windows Server Failover Clustering (WSFC) set up also .

    Yes you do

    sqldba725 (9/4/2013)


    Any other recommendation for setting MS cluster...

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

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

  • RE: Generate script for database Restore

    gary1 (9/3/2013)


    I found a very good script to generate script for database Restore for native sql server.

    http://sequelserver.blogspot.com/2009/04/generate-restore-scripts-from-backup.html

    Can you please let me know how we can modify the same to...

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

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

  • RE: unable to connect to server

    New persopn (9/3/2013)


    here we dont have the san setup. we are using internal storage.

    can you provide more detail on the local storage setup such as raid, number of disks and...

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

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

Viewing 15 posts - 3,946 through 3,960 (of 9,244 total)