September 28, 2011 at 6:49 am
Dear All,
I Have a data base in sql server 2005 having huge amount of data of 10 finanacial year.
I want to archeive 2 yras data in a separate database.
If anybody help, then highly apreciated.
please scpecify the steps.
Thanx in advance
Regards,
San
September 28, 2011 at 7:16 am
Easiest way is to backup and restore as a new database (new name), delete the data in each database you don't need.
If you do this regularly, you need to build a series of scripts that will insert data in the archive database from the main database using some criteria. I assume you can tell which transactions are old and which are not. Then delete the old data from the main database.
September 28, 2011 at 9:23 am
As Steve mentioned if you would like to do this in regular basis you can use partitioning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply