Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 9,241 total)

  • RE: query to generate the script

    Manual or automatic failover are not available for asynch mirror sessions, do you have any?

    Where asynch is in force you'll need to set Safety on, run from the principal

    ALTER DATABASE...

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

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

  • RE: Queries on High availibility in sql 2012

    are the sql server services running??

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

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

  • RE: Is it realistic to base recovery on mdf and ldf backups?

    suedunham2 (12/15/2014)


    My recommendation to my manager is to base recovery on .bak and .trn files. However the .mdf and .ldf files can be backed up without being detached and I...

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

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

  • RE: mirror test failure

    Have you checked the state of the mirror endpoints? As a matter of course I would restart them.

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

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

  • RE: Backup compression didn't work.

    yes, unfortunately TDE negates backup compression.

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

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

  • RE: Log ship all databases under one job

    Shahzadi (11/26/2014)


    The only drawback is that if somehow secondary server goes offline for an hour or so, log shipping will not catchup. but in normal log shipping everything comes backup...

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

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

  • RE: SSL and Certificates in SQL Server 2008 R2

    what did you do in the end?

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

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

  • RE: Queries on High availibility in sql 2012

    it shouldn't be a problem where the instances are already installed, ideally you would want to setup your cluster and soak test before you start deploying applications (clustered or non...

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

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

  • RE: Sql Clustering validation warnings

    you don't have to set a gateway on your NIC if you don't want to, but you won't have any ability to go outside your own network.

    During cluster creation the...

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

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

  • RE: Problems while sql clustering on windows 2008 R2

    so, if i'm reading corect now you're not deploying a failover cluster instance of sql server you're deploying standalone instances and intend to use AlwaysOn availability groups, is that correct?

    Can...

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

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

  • RE: Drive Allocation Unit Size(cluster) for Data/Log/TempDB drive/SystemDB drive/SQL installation drive

    This is not performed exclusively on its own, it's part of a serious of steps and includes setting the underlying RAID stripe size and partition offset.

    What work have you done...

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

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

  • RE: DB Read only Copy

    cdye (12/11/2014)


    I am hoping to get some guidance on the best approach for a read only copy of a database that is ~ 1TB. The primary database is fed...

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

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

  • RE: tempdb blocking

    one will insert rows to an already allocated table and one will have to create the table and employ all the I\O processes around the page allocations, as well as...

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

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

  • RE: Problems while sql clustering on windows 2008 R2

    can you post some of the errors

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

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

  • RE: Changing NAME and IP ADDRESS of machine where SQL Server is hosted.

    no problem, thanks for posting back

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

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

Viewing 15 posts - 2,596 through 2,610 (of 9,241 total)