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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DB Split

Author  Topic 

amirbesic
Starting Member

3 Posts

Posted - 2007-02-26 : 23:56:35
I have rather large SQL 2000 data base ( 400gb) that contains data going back more then 10 years .
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

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-26 : 23:59:37
Cross post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79713


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -