Forum Replies Created

Viewing 15 posts - 3,691 through 3,705 (of 9,244 total)

  • RE: compressing read only file groups

    muthyala_51 (1/22/2014)


    Perry Whittle (1/21/2014)


    What steps have you taken so far?

    I used the command COMPACT /C /S source destination to compress all the read file groups. It worked fine. But I...

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

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

  • RE: backup, copy is working however, restore is not working

    Are you using Log shipping or your own variation of it

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

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

  • RE: compressing read only file groups

    What steps have you taken so far?

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

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

  • RE: Adding New Node to exisiting SQL Server 2008 R2 Cluster

    r.mishra (1/21/2014)


    Hi,

    Can anyone please add the steps to add the 2nd active node on already running active/passive clsuter mode please

    Thanks

    Rkm

    Create a new thread detailing the current setup and I'll be...

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

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

  • RE: Verify Backups

    Talib123 (1/20/2014)


    Perry Thanks, but the query didn't return anything. I am running my backups via Maintenance Plans (SSIS).

    Hanshi I need the script to run via my CMS to see...

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

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

  • RE: Run Script in each databases in sql server

    If you have a central management server configured you could group execute the query there across pre defined instances

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

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

  • RE: Clustering

    Symantec do offer a VCS management pack for SCOM

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

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

  • RE: New Cluster installation vs Advanced Cluster preparation

    smitty-1088185 (1/20/2014)


    What's the difference between the old "New SQL Failover Cluster installation" option

    This is not an old option, it's perfectly serviceable to deploy a single small clustered instance of SQL...

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

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

  • RE: Clustering

    smitty-1088185 (1/20/2014)


    If you use Microsoft SCOM monitoring in your environment like we do, I would stick to Microsoft clustering

    Really and why exactly is that?

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

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

  • RE: Upgrading from SQL 2012 Standard to 2012 Enterprise

    I believe it is a fairly quick operation based on another users experience of this

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

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

  • RE: How to see foreign key relationship

    Fill your boots mate, I'd appreciate your input 😉

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

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

  • RE: Upgrading from SQL 2012 Standard to 2012 Enterprise

    I wouldn't have thought so if you're smart you'll take backups before you begin.

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

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

  • RE: Copy logins with their password

    The script doesn't carry server permissions, but with a little imagination and querying the correct catalogs its easy to accomplish.

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

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

  • RE: AlwaysOn config?

    That's because they don't under stand how multi node clusters are configured and operate 😉

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

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

  • RE: 3-Node, 3-Instance SQL Cluster -- Static IP address and Port 1433 question

    jpSQLDude (3/28/2013)


    I searched hard and many people have a similar question, but I cannot find a clear answer. I have a 3-node Windows Server 2008 R2 cluster, with 3 Named...

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

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

Viewing 15 posts - 3,691 through 3,705 (of 9,244 total)