I have a database that has 10 million records from june 1 1999. I need to cut short the size of the database and keep records only from aug 1 1999. This is a replication database on the publishing server which has to be replicated on the subscribing server. I am using SQL Server 6.5.
Anyone can suggest ways of doing this. One idea i got is to truncate the database into parts, BCP out data into a flat file and then upload.
Please give ideas about it.
Pranav