I have been tasked to come up with a workable DR solution for our SQL environment. However, the DR box has a major restriction as the data drive is 2.25TB as opposed to a 3.50TB drive used in production. Obviously, this contravenes the fundamental tenet of making the DR hardware the same as production.
Now, to the specifics. We have several large databases (ranging from 100GB to 750GB) that are partitioned into filegroups by date function (monthly filegroups) as these databases hold several years worth of historical data. Hence, filegroups containing data over a year old are marked read-only.
Is it possible to have a DR database which is a subset of filegroups from the larger production database? For example, say production has 3 filegroups: 2008 (r/o), 2009 (r/o) & 2010 (r/w). Can a DR database then consist of only 1 filegroup (2010)? If so, can log shipping be configured for the r/w filegroup?
If not, the workaround would be to create a archive database for historical data which could then be sacrificed in a DR situation, whilst the current database with live data can be log shipped. FWIW, full database backups are made onto tape and held offsite. Is the filegroup method a workable solution?