Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    7

    Unanswered: Definition of BCV

    Could someone explain to me what the acroymn BCV means and how it is applied with an SQL database?
    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You probably mean BCP, the Bulk Copy Program provided as a SQL Server utility with the SQL client tools.

    You might actually mean BCV if you are using EMC storage, in that context it means Business Continuation Volume.

    -PatP

  3. #3
    Join Date
    Jun 2004
    Posts
    7

    I mean BCV as in Business Continuation Volume

    Thanks Pat for the response .... I did mean Business Continuation Volume because our client is using EMC storage. Can you explain to me what this actually is and how it is benefical as a tool to use?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Actually, EMC does a better job explaining how to use BCVs with SQL Server than I can. We've never gotten them to work to my satisfaction.

    The basic idea is that a BCV will allow you to mirror data in real time. In SQL 7.0 hooks were added, which were refined in SQL-2000 to allow an application to "freeze" a disk volume. This freeze would effectively flush the disk buffers to disk as of a specific point in time, almost as though the database had been stopped (to detach it). The theory is that you could mirror a BCV volume to a production volume, freeze the SQL files, break the mirror, then "thaw" the SQL files again, all without the end user knowing or caring that anything had ever happened.

    Anywho, see the EMC document for a better description. While I love EMC in general, we (my firm working with EMC) were never able to make BCVs work in production.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •