Archiving

Can any one tell me about the Archiving the database concept. How can we do
archiving in SQL Server.
Thanks
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@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John" <naissani@.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
>
|||See if this helps: http://vyaskn.tripod.com/sql_archive_data.htm
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"John" <naissani@.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