Unanswered: Table and filegroup question / confirmation
This is not as much as question as it is a request for confirmation.
The way I understand it, SQL-server 2008 supports moving a specific table beteen filegroups.
I have table Cars with the database motors_crm, made up from three files located on different SANs.
One of the tables is a huge history on who rented what car for what period. After a year and 2 million cars, this table becomes insanely huge.
So I would like to create an extra datafile for the Cars database, create a renting history archive table (for all but current year) and move that arcive table to fairly cheap SAN for arhiciving purposes.
This should be possible, Right?
But! Can I prevent SQL-server from assigning other tables to that data file? In other words isolate a specific datafile for one specific table?
IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....