Save a Smaller version named MyDatabaseArchive2012?
Do you have a client that has a huge database and a hard time letting go of old data?
How To Archive A Database
Why Archive Databases?
Would I delete the records from the main database table when archiving as it's already imported to the archive database, correct?
Thanks for the info.
That should be a question you can aswer for yourself. If you are trying to use this method to keep your file size and number of records down, it won't achieve that end if you don't delete the records after importing them into the archive table/file.
It's a good idea to schedule this kind of thing so that you save a back up copy just before the exported records get deleted. That way you have a backup to restore from if something goes wrong.