Forum Replies Created

Viewing 15 posts - 2,191 through 2,205 (of 9,244 total)

  • RE: Whats the exact link where I can download SQL Server 2012 EVALUATION edition ?

    the first link lists as SQL Server 2012 RTM

    the second is 2012 with SP1

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

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

  • RE: enabling RCSI.....correctly

    SQLJay (4/9/2015)


    Reading one the replies above states the latter statement is not necessary if set READ_COMMITTED_SNAPSHOT has been executed

    That's not entirely correct. This link details the following

    Microsoft TechNet


    When to Use...

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

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

  • RE: Relocating the Log file of a merge subscription database.

    you're welcome

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

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

  • RE: Relocating the Log file of a merge subscription database.

    Maddave (4/10/2015)


    Sorry to jump in on this thread, but can I clarify if this is the recommended way to do this job just for a database which is involved with...

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

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

  • RE: Filegroup backup questions

    Wandrag (4/10/2015)


    BUT - it still needs the transaction log backups (all of them) before I can bring the database online...

    Why?

    What am I missing here?

    To bring the filegroups up to the...

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

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

  • RE: SQL 2014 Clustering, what now.

    check my stairway guide to SQL HA on this site starting at the link below

    http://www.sqlservercentral.com/articles/FCI/107536/[/url]

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

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

  • RE: Logshipping

    ramyours2003 (4/9/2015)


    where the .tuf file is locatied in Logshipping ?

    A simple filesystem search for *.tuf should suffice

    free_mascot (4/9/2015)


    Usually you will find it at the same place where copy of .trn...

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

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

  • RE: Backup Failed in SQL 2014

    check the log for further error details and post these back

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

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

  • RE: SQL 2014 Clustering, what now.

    check for hardware and software failover scenarios.

    Terminate the sqlservr.exe process on the node that owns the resources

    Disconnect the network cable

    Shutdown the node

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

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

  • RE: The media family on device "xxxx.bak" is incorrectly formed. SQL Server cannot process this media family.

    sounds like its a Litespeed backup, a Litespeed backup will not be recognised by the database engine, the backup format is different.

    Litespeed will, however, recognise and restore a native...

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

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

  • RE: SQL server Encription

    can you expand a little more on what you're trying to do

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

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

  • RE: Working with Dynamics G - understanding security and support with availability groups

    no I don't.

    Cant see that the passwords have to be reset, there must be something else going on to explain this

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

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

  • RE: Working with Dynamics G - understanding security and support with availability groups

    are you scripting the logins across sql server versions?

    That's about the only time it'll fail as the encryption changed between 2008 and 2012

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

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

  • RE: Transaction Log Shipping (SQL Server 2008 R2)

    vomster37 (4/2/2015)


    We have a primary database 'A' which has a secondary database 'B' setup in "norecovery" mode on another server which works fine.

    What I'm trying to do is setup...

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

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

  • RE: Remove resource from 2 node cluster

    The SQL server service resource itself usually has a dependency on any disks that are part of the instance

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

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

Viewing 15 posts - 2,191 through 2,205 (of 9,244 total)