Forum Replies Created

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

  • 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" 😉

  • RE: Failed to Form a cluster. Witness was not accessible

    hdctest (4/2/2015)


    Hello,

    I have a SQL cluster and the Witness disk status shows as online but the passive node shows a "cluster event" that the passive node failed to form a...

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

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

  • RE: Why do I leave my DB in Restoring State after attaching to the instance?

    Thinky Night (4/7/2015)


    Hi All,

    Why do I leave my DB in Restoring State after attaching to the instance? Could not this fire a redo activity on Transaction Log?

    Or, How does sql...

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

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

  • RE: Always On with Cluster + Standalone Question/Discussion

    yb751 (4/6/2015)


    Do you mean that JUST the AO replica will need to be manually failed over?

    Yes exactly that. The FCI will behave as usual.

    If the FCI is unavailable then failover...

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

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

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