Home > IT Answers > Storage > Archiving databases on SQL Server 2000
SQL Server Ask the Experts
2,585 pts.
 Archiving databases on SQL Server 2000
Archiving, Database, SQL Server 2000
Could you help me to estimate how long it takes to archive 400 GB records from one of our test databases located on SQL Server 2000? Also, what would be the best approach?

Software/Hardware used:
ASKED: June 19, 2008  8:02 PM
UPDATED: July 4, 2008  8:58 AM
RELATED QUESTIONS
Answer Wiki:
That will all depend on how wide the records are. It could take anywhere from a few minutes to several hours.
Last Wiki Answer Submitted:  June 19, 2008  9:51 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,550 pts.
 

Have you considered upgrading to SQL Server 2005. Archiving like this can take miliseconds in 2005 using partitioning. Standard MS Support for SQL Server 2000 has now lapsed so it is really time to bit the bullet and upgrade -although SQL Server 2008 is just around the corner.

Ritchie1
 210 pts.