Hi Guys,
IN MY SQL SERVER 2000 database i heve some tables holding
20 million rows i want to archive this tables . but while
taking reports i should be able to get this transaction i
am using transactional replication for reporting.
to achive archiving should i
a)delete old data and insert into another table and create
a view to take reports
or
b)delete from main server and keep all the data in the
report server for reporting
pls adivice the best way
Thanks
Biju