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 style='text-decoration: underline;' href="http://www.microsoft.com/mvp" target="_blank">http://www.microsoft.com/mvp</a>
Blog: <a style='text-decoration: underline;' href="http://www.msmvps.com/epprecht/" target="_blank">http://www.msmvps.com/epprecht/</a>
"John" <naissani.DeleteThis@hotmail.com> wrote in message
news:edyGapFEFHA.1600@TK2MSFTNGP10.phx.gbl...
> Can any one tell me about the Archiving the database concept. How can we
do
> archiving in SQL Server.
>
> Thanks
>
><!-- ~MESSAGE_AFTER~ -->
>> Stay informed about: Archiving