Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 9,244 total)

  • RE: How to Create a Corrupt SQL Server Database

    You're welcome

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

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

  • RE: Upgrading only OS for sql server 2005 2 node cluster server.

    I wouldn't recommend running SQL Server 2005 on Windows 2008 either, it's frought with issues :w00t:

    If you really want to though this is what i'd do (and assuming the hardware...

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

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

  • RE: will cluster failover if the nodes are on different service pack levels?

    vsamantha35 (8/12/2014)


    Hi,

    Since I don't have a testing environment, I am seeking help on this.

    In a 2-node SQL Cluster, if Node-1 is on SQL 2008 SP3 and Node-2 is running on...

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

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

  • RE: 2008 R2 Slipstream install

    Jpotucek (8/11/2014)


    The std EXE file is in the same folder as the extracted files - so the answer is both.

    Once the files are extracted you have to run the...

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

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

  • RE: Multi Instance Cluster - Different Editions

    Philip Barry (8/11/2014)


    Does anyone know if Microsoft does or does not support a cluster co-hosting SQL Server 2008 R2 Standard and Enterprise Edition instances?

    I've been looking for definitive references either...

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

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

  • RE: 2008 R2 Slipstream install

    See my guide at this link[/url] for more info

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

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

  • RE: 2008 R2 Slipstream install

    Jpotucek (8/11/2014)


    My SQL Server 2008 R2 setup.exe is located here:

    E:\SQL_Server_2008\SQL_Svr_Standard_Edtn_2008_R2

    My Service Pack 2 media is located here:

    E:\SQL_Server_2008\SQL_SP2

    My CU 3 media is located here:

    E:\SQL_Server_2008\SQL_CU3

    From a DOS prompt, I...

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

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

  • RE: Creating a Test DB from a full backup of Prod

    you're welcome

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

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

  • RE: error in starting DB coz of a secondary log file

    kesavan.rv (8/11/2014)


    HI DBA's,

    I have issue in starting a DB..

    details:

    I have created secondary log file in separate drive to perform an activity,late it was removed in DB Property.

    yesterday backup was taken...

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

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

  • RE: Join Domain AFTER SQL is Installed?

    dan-572483 (8/8/2014)


    All:

    I have some VMs that with SQL Server that were built as stand-alone servers a few years ago for my own self-directed training. After buying some more powerful...

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

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

  • RE: Running multiple TDE encryptions at once...

    Lynn Pettis (8/9/2014)


    Can you provide the STIG?

    Yep, here you go matey 😀

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

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

  • RE: Change SQL Server 2012 Collation

    hiram.osiris (8/8/2014)


    There's also a workaround that I saw once here:

    1.-Stop SQL Server service from Configuration Manager

    2.-Open CMD console as administrator and go to the following path: C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012(Here...

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

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

  • RE: SQL Encryption - Create Certificate

    swoozie (8/8/2014)


    We were provided those scripts and told to run them if encryption didnt allready exist.

    Who provided them

    swoozie (8/8/2014)


    This is where I am having a disconnect between understanding...

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

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

  • RE: How to Create a Corrupt SQL Server Database

    roberto.regidor (8/8/2014)


    Hi Perry

    The last image of the post says

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB

    Yes it clearly is incorrect in this case

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

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

  • RE: SQL Encryption - Create Certificate

    The create cert you specified was incorrect for a restore or for a new cert. What do you want the certificate for, are you encrypting within sql server?

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

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

Viewing 15 posts - 3,076 through 3,090 (of 9,244 total)