SQL Server Performance

Mirroring Help

Discussion in 'SQL Server 2005 Database Mirroring' started by sachinsamuel, Nov 20, 2007.

  1. sachinsamuel New Member

    Hi Experts,
    I have configured mirroring and its working fine. But in an article from microsft I came accross a line
    • The principal database must be in the FULL recovery model. Log records that result from bulk-logged operations cannot be sent to the mirror database.
    But when I do a BCP, Select into or Bulk insert to the principal server I can still see the changes/or new rows inserted in mirrored database's snapshot. How is this possible?
    Please help. Thanks in advance.
  2. satya Moderator

    Are you changing the recovery model of database while performing this operation?
  3. sachinsamuel New Member

    No I am not. Moreover mirroring cannot be done in any other recovery model other than FULL recovery model.

Share This Page