I seem to remember some time ago reading an article saying I could split a SQL Server database into more than one file, allow me to elaborate.
I have a database that has a dozen or so tables that reflect statistics for the last 'n' years. The tables are called
History2008 etc and the current year's table is just called
History. All the previous years tables contain static data (won't be changed) and I would like to move these files to another file that is linked to the main database. As the old data tables contain foreign keys to
Suppliers etc I can't just copy these tables to a new database.
The whole idea is to reduce the size of the database and the backups as I can make one backup of the 'old' data and that will not change until next year.
Any thoughts? Ideas? Guidance?