Archiving

Hi

SQL Server has no such concept as 'archiving' as it does not need it. A
table can have virtually unlimited number of rows, and if a DB is designed
properly, it will perform as well with 100 or 100 billion rows in table.

If an application want to save records into a separate are for long term
read only use, the application developers must put it into their code.

A backup in SQL server is there to make a copy of the data in the databases
for writing to some other media for recovery purposes in a DR scenario.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike DeleteThis @epprecht.net

MVP Program: <a rel="nofollow" style='text-decoration: none;' href="http://www.microsoft.com/mvp" target="_blank">http://www.microsoft.com/mvp</a>

Blog: <a rel="nofollow" style='text-decoration: none;' href="http://www.msmvps.com/epprecht/" target="_blank">http://www.msmvps.com/epprecht/</a>

"John" wrote in message

 > Can any one tell me about the Archiving the database concept. How can we
do
 > archiving in SQL Server.
 >
 > Thanks
 >
 >