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 |
|
amirbesic
Starting Member
3 Posts |
 Posted - 2007-02-26 : 23:45:51
|
| I have rather large SQL 2000 data base ( 400gb) that contains data going back more then 10 ears . I would like to divide ( split) that data base into 2 database One that would have data older then 01/01/2006 and another that would consist of data that is from 01/01/06 and newer . Can anyone provide me some guidance on how to do this. Thanks Amir |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-27 : 00:04:32
|
| You will need to consider data that hasn't changed between the two date ranges.Can you create partitioned views and place the old data on a different filegroup. That would mean you don't have to change any access.This is catered for in v2005 - could you upgrade?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
amirbesic
Starting Member
3 Posts |
Posted - 2007-02-28 : 10:38:19
|
| Is there anybody who could help me with my request . |
|
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-02-28 : 15:11:26
|
| You can partition your database. Look in Book online for information on partitioning data. Basically, you will create multiple tables to store the older data. Then create views to bring this data back together again when needed. Lots of advantages to partitioning, such as quicker backup times, faster access to information, parallel queries etc. But it does take some planning and testing. Alos some current views and procedures may have to be modified.Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
|
|
|
|
DB split