Forum Replies Created

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

  • 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" 😉

  • RE: unable to connect to server

    What have you done to address the issue below??

    New persopn (9/2/2013)


    We checked through the event logs and found that there were fatal errors on drive, and looks like disk issue....

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

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

  • RE: Upgrade SQL Server 2012 from 2008 R2

    SQL Surfer '66 (9/2/2013)


    Perry Whittle (8/30/2013)


    just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

    In case it gets necessary: You...

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

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

  • RE: SQL 2012 AlwaysOn failover/failback

    OLDCHAPPY (8/30/2013)


    I'm looking into using SQL 2012 AlwaysOn for DR purposes in our shop and don't find much information on the failback process. Can anyone comment on the failback process...

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

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

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