July 27, 2004 at 4:29 am
I read somewhere that if you use TRUNCATE TABLE then this is an unlogged process and therefore log-shipping won't work. Is this correct?
Secondly, I have two development boxes and I want one box to be fail-over for the other.
If I set up log shipping will any changes or additions to database objects i.e. stored procedures and views be propogated to the fail-over box?
July 27, 2004 at 8:03 am
Well, truncate table is a non-logged operation in the sense that it doesn't log each and every row that is deleted but it does log data pages deallocation. When I ran my test with log shipping setup, it did show the effect of truncate table so the data was deleted even on the standby server when I applied the log (backed up after TRUNCATE table command).
Yes, all changes to your database objects will be propogated to the standby server since they all will be written to log of the primary server.
HTH
-Rajeev Lahoty
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply