Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 9,241 total)

  • RE: DB Shrink post mortem - file sizes and freespace

    GilaMonster (1/14/2015)


    For user databases isn't not particuarly critical.

    I would say it's just as critical, you still have a proportional fill rate and files of differing size\freespace will just cause the...

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

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

  • RE: How to set a Database to suspect mode For Practical test HA?

    sm_iransoftware (1/14/2015)


    I Want to test for Automatic switch between primary and secondary.

    How do i do it ?

    Shutdown the node the primary is running on

    sm_iransoftware (1/14/2015)


    How to set suspect mode...

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

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

  • RE: Failover cluster in SQL Server 2012 std. edition

    Joy Smith San (1/14/2015)


    Hi,

    We have a requirement to configure a 2 node cluster (active/passive).

    As per my understanding, we do it in SQL Server 2012 std. edition. Please confirm.

    Thanks,

    San.

    You may...

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

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

  • RE: Always on with sql server 2014 or 2012

    sm_iransoftware (1/14/2015)


    Hi

    We need to run Always on , on our sql servers.

    Is there any upgrade or benefits on sql server 2014 about Always on ?

    Or

    Should I Upgrade to 2014...

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

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

  • RE: Want to ensure I'm not going to break my SQL Server service account

    jasona.work (1/12/2015)


    I'm working on cleaning up some bad choices made during SQL setup on a few boxes of mine, and one of the items on the list is getting the...

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

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

  • RE: Issue with the automatic failover on AlwaysOn AG

    What quorum configuration have you employed for the 2 node cluster?

    What settings have been applied to the AlwaysOn group, synch or asynch, manual or auto failover?

    Are the databases synchronised?

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

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

  • RE: DB Shrink post mortem - file sizes and freespace

    JarJar (1/8/2015)


    I recently ran a db shrink on a large database to recover a lot of unused space within the db and release back to the SAN. I shrank each...

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

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

  • RE: Ola's Maintenance Solution- differential backups have .bak instead of .dif - will this cause any problems with restore

    Grant Fritchey (1/8/2015)


    And I'm with Perry. I'd use .bak for all sorts of backup files, but differentiate them in the name.

    Or .TRN for tran log backups. The Microsoft provided defaults...

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

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

  • RE: Virtualised Multi-Instance SQL Server Cluster - Processor Resource Management

    bryanasaurus (1/8/2015)


    Hi - We're in the process of implementing a multi-instance SQL 2014 guest cluster on Windows 2012 R2. To our dismay, it seems that Windows System Resource Manager...

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

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

  • RE: Ola's Maintenance Solution- differential backups have .bak instead of .dif - will this cause any problems with restore

    i would put the full or diff identifier in the filename

    i.e. mysqlbackup_full_20150106_1120.bak

    mysqlbackup_diff_20150106_1130.bak

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

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

  • RE: Certificate for encryption

    GilaMonster (1/8/2015)


    jacksonandrew321 (1/8/2015)


    Yes, I did and path is valid.

    Except that it's missing a file name in one place and missing the entire path in the other.

    Check the permissions on the...

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

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

  • RE: always on

    ramyours2003 (1/7/2015)


    Can any one send me the document how to configure and trouble shoot the always on in sql 2012 ?

    Follow my stairway series on this site starting at...

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

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

  • RE: Transparent Data Encryption

    dmc-608719 (1/7/2015)


    As the title says.. I am looking to implenet TDE. I was looking at this article

    http://msdn.microsoft.com/en-us/library/bb934049(v=sql.110).aspx

    Before proceeding with these steps I wanted to look a little more at...

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

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

  • RE: SQLServer HA RTO 100%

    sounds like what they're looking for is Oracle RAC

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

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

  • RE: how to clear AD after destroying windows cluster

    if you have access to dns clean up the dns records too

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

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

Viewing 15 posts - 2,521 through 2,535 (of 9,241 total)