I have a company with several divisions on a SQL 2000 database. The database contains product information, sales, customers, etc. - basic e-commerce stuff. Total size is a little under 1GB. One of the divisions has been spun off, and I need to split the database so that the records pertaining to that division are replicated in a new database, and completely removed from the existing database.
What is the best way to accomplish this?