Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Prem.spr
Starting Member
3 Posts |
 Posted - 2012-01-19 : 01:22:29
|
| Hi friends,i have a database full backup from 2088 year to till now ,now i want to restore the database of data only 2009 in some other instance means from jan 12009 to dec31 2009how to restore it like this,please help mePrem Reddy |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-19 : 03:23:07
|
| There's no way to restore selective data unless your database was divided into filegroups and the various years of data in different filegroups. It it wasn't set up that way, you'll need to restore the whole thing and then remove the data you don't want.--Gail ShawSQL Server MVP |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-19 : 04:08:55
|
| Might you, instead, "move" data from the relevant time periods into separate tables (so called "horizontal partitions"), so you can query them selectively, improve performance (because queries will only query the relevant, smaller, data sets) but also have the ability to query the combined historical data, across multiple partitions, if you need to. |
|
|
|
|
|
|
Restore a databse from date to ndate