Forum Replies Created

Viewing 15 posts - 3,271 through 3,285 (of 9,244 total)

  • RE: Using Encrypted Backups in SQL Server 2014

    ah right i see, yes it was commented out 🙁

    I've asked Steve to fix this

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

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

  • RE: Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

    Hi Ben

    great stairway, very good reading

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

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

  • RE: Using Encrypted Backups in SQL Server 2014

    george sibbald (5/15/2014)


    Perry, thanks for the article.

    If you have a test server on which you may restore backups from multiple prod servers how is that handled? Do you need to...

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

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

  • RE: Log shipping and log chain

    william.rees.howells (5/13/2014)


    Hi guys I have a couple of quick questions about log shipping.

    I have set up a quick example on our test box and so far as I can tell...

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

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

  • RE: Anyone going to SQL Bits 17-19 June Telford ICC, UK

    aaron.reese (5/13/2014)


    Is anyone going to SQL bits who would like to meet up on the Wednesday or Thursday.

    @Gail - I know you are speaking. I would consider it an...

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

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

  • RE: Downgrade to SQL 2014 Standard edition after "accidental" install of Enterprise? :)

    I'm pretty sure you'll find the edition downgrade part is relative for when the licensing model is changing (e.g. from Core to server+CAL)

    Not what you think it's for 😉

    Check with...

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

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

  • RE: In-place upgrade sql 2008 enterprise edition to sql 2014 standard

    you'll need to install a new instance, this is not a supported upgrade path

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

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

  • RE: What is the user impact to drop a noncluster index on table while in use?

    you also wont be able to drop it if it's currently in use

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

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

  • RE: Downgrade to SQL 2014 Standard edition after "accidental" install of Enterprise? :)

    Theo Ekelmans (5/12/2014)


    so why can't i downgrade?

    ...............................................

    but why can't i downgrade?

    Any ideas anyone?

    Theo Ekelmans

    The Netherlands

    You'd need to ask someone from Microsoft!

    The SQL Server 2014 edition upgrade section of this link...

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

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

  • RE: MDF, LDF and Tempdb files placement drive?

    ananda.murugesan (5/12/2014)


    Total HDD 300 GB * 2 = 600 GB

    No, in a RAID 1 configuration 300GB * 2 = 300GB

    ananda.murugesan (5/12/2014)


    Total HDD 600 GB * 5 = 3000 GB

    No, in...

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

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

  • RE: MDF, LDF and Tempdb files placement drive?

    ananda.murugesan (5/10/2014)


    is it really get performance on different logical array in single Physical arrary controller?

    If you have 4 physical disks attached to the controller and you provision 2 disks...

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

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

  • RE: Identifying what caused Corruption

    Ah so its a virtual machine, this wasnt made known before. Are these virtual hard disks or raw device mappings?

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

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

  • RE: In Log shipping Copy Job is not Running successfully...

    sinthanaisirpi.k (5/9/2014)


    Hi Jagdeesh,

    Have you got the solution? I am also getting the same error. Pl help me out

    Have you checked permissions to the primary backup share for the secondarys sql...

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

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

  • RE: AlwaysOn: Client (Re)Connecting to wrong server after fail-over?

    Doh, sorry didnt see this

    ffoerster (5/6/2014)


    No ReadOnly Routing.

    Have you double checked the connection string, are you using std TCP port or non std?

    Was this an automatic failover or a manual...

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

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

  • RE: SQL 2014 AG with 2012 Replica

    Found it. The "Compatibility Support" section of this link details the following

    RESTORE (Transact-SQL)


    Note

    No SQL Server backup be restored to an earlier version of SQL Server than the...

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

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

Viewing 15 posts - 3,271 through 3,285 (of 9,244 total)