Forum Replies Created

Viewing 15 posts - 5,326 through 5,340 (of 9,241 total)

  • RE: How to check cluster config with T-SQL queries

    Most of the cluster information is available from the Windows cluster itself, What information do you require?

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

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

  • RE: SQL 2012 AlwaysOn Node/File Share Quorum Majority

    JJ-469859 (7/13/2012)


    According to my testing, people are in for a rude awakening with using AlwaysOn Availability groups with the default settings for certain scenarios. For instance, according to my testing...

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

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

  • RE: Upgrade to 2012

    Bobby Glover (7/12/2012)


    Thinking of upgrading to SQL 2012 maybe early next year, are there any GOTCHAs or known issues with 2012.

    Which version are you upgrading from?

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

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

  • RE: backup index

    laddu4700 (7/13/2012)


    how to backup the sql 2008 database indexes? thanks

    Backup your database(s) regularly and all of these objects will be backed up 😉

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

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

  • RE: Whole Disk Encryption and TDE

    TheSQLGuy (7/12/2012)


    Security mgr wants to put PGP Whole Disk Encryption on all volumes of one of my SQL 2008 R2 boxes. The databases are already encrypted with TDE, but...

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

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

  • RE: Log shipping error

    savethytrees (7/12/2012)


    Run the following queries to find which file was the last one to be copied and which file was the last one to be restored.

    The following query will give...

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

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

  • RE: Disk Alignment best practice - Help !!

    you're welcome 😉

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

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

  • RE: Adding data & index file best pratices?

    ananda.murugesan (7/12/2012)


    1. If more then 200GB primary data file reached, I assumed need to create one more datafile for improve database perfromance?

    That assumption is incorrect.

    ananda.murugesan (7/12/2012)


    2. Index data file, we...

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

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

  • RE: Log Shipping Restor job failed

    if your secondary ever shuts down again for long periods either keep a copy of the backups that havent been restored or perform a differential on the primary and apply...

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

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

  • RE: Disk Partition Alignment

    you're welcome 😉

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

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

  • RE: Log shipping error

    Sorry I'm confused I thought we were discussing log shipping!!

    The backup and restore information is held in MSDB, query the tables here for this info

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

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

  • RE: Adding data & index file best pratices?

    Firstly, you seem to have a misunderstanding of files and filegroups, take a look in books online and familiarise yourself with them. Now to cover your questions

    ananda.murugesan (7/12/2012)


    1. Adding datafile...

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

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

  • RE: Increased Time to Complete Backups

    Shaira (7/10/2012)


    I have 28 DBs on SQL 2008. Four days ago my nightly full backups were taking on average about 3 hours, then suddenly they started taking 5+ hours...

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

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

  • RE: Disk Alignment best practice - Help !!

    SQLQuest29 (7/11/2012)


    Thanks a lot Perry !!

    Very helpful.

    Out of curiosity, is there any way that the relation between the disk# and the drive (e.g c: ,d:) can be found meaning they...

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

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

  • RE: Disk Alignment best practice - Help !!

    That statement is based on the example immediately preceeding it.

    Start from the heading Partition Alignment on page 25 and read through thoroughly. This is descriptive of the requirements

    EMC Symmetrix with...

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

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

Viewing 15 posts - 5,326 through 5,340 (of 9,241 total)