November 12, 2008 at 2:27 am
Hello all,
we are planning to implement SQL Server 2005 SP2 Enterprise Edition on two Windows 2003 production server in a Data Warehouse (DWH) environment. One of the servers will be the database mirror for the other one. We will always have a window of data available in the DWH, meaning we load new monthly data and remove the data of the oldes month.
Due to the big amount of data in one of the tables we will partition this table (by month).
An efficent way of deleting data from this partitioned table is to move the partition containing the data to be deleted to a nonpartitioned, empty copy of that table and drop that second table.
We need to understand: Is this scenario feasible in a mirroring environement?
Thanks...
JM
November 12, 2008 at 3:43 am
Mirroring simply replicates all (logged) transactions on the mirror database.
Since switching partitions is logged in the transaction log I don't see any reason why this shouldn't work.
[font="Verdana"]Markus Bohse[/font]
November 12, 2008 at 9:00 am
Thanks a lot Markus!
JM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply