November 11, 2007 at 8:22 pm
Hi All,
I have just one confusion which I want to clear
In logshipping if I insert records through bulk commands in primary database so those records will reflect on the secondary database or not coz as per my knowledge records which we insert through bulk commands will directly update the .mdf file of the database.
Regards,
Austin
November 11, 2007 at 9:21 pm
Yes. The data will be restored to the standby server.
Once log shipping is set up, it backs up the transaction log from the primary server and restore to the standby server. The primary database should be in full recovery model for log shipping which means bulk insert will be recorded in the transaction log, thus it will be copied over to the database on the standy server.
The full recovery model guarantees the least risk of losing work if a data file is damaged. For a database with this model, SQL Server fully logs all operations, so every row inserted through a bulk copy program (bcp) or BULK INSERT operation is written in its entirety to the transaction log...
http://msdn2.microsoft.com/en-us/library/aa224769(sql.80).aspx
November 11, 2007 at 11:37 pm
Thanks Vivien ,
But can I use Bulk logged recovery model in log shipping.....
Austin
November 12, 2007 at 2:26 am
Austin, basically, yes you can use bulk-logged. the bulk logged operation is repayable when restoring the log, so it will work.
---------------------------------------------------------------------
November 12, 2007 at 6:03 am
Thanks George...
Austin
November 13, 2007 at 12:07 pm
For your reference:
The databases in a log shipping configuration must use the full recovery model or bulk-logged recovery model.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply