Archiving Database?

Archiving Database?

Post by Martin Iever » Sat, 12 Jan 2002 06:47:55

I am trying to archive a database on a schedule. Say yearly. I would like to
move the data files into a storage location but may want to go back and look
at them.
Is the best method to use the Analysis services?
Or should I just make a back up of the DB and then clear the tables?

Thanks for any help,


Archiving Database?

Post by Bill Toleman[M » Sun, 13 Jan 2002 01:40:38

Hard question since it depends on your needs, your idea of backup would
work however you would need to reload the database to view it. Anouther
method would be to have an archive server that stays running and do inserts
to it based on a date stamp and then deletes from the main also based on
the date stamp. That way you could always view the archived data without
doing anything.

Bill Toleman [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit


1. Archiving databases/database servers?

Reply-to: comp.databases,poster

Are there any client/server databses that can do archiving as well as
backups?  By archiving I mean that I may write data to a removable media,
such as MO or Optical, remove them, but the database "knows" of these data
I can recall them.  Suggestions, references and names of products would be
all very much welcomed.


Due to the double-blind, any mail replies to this message will be anonymized,
and an anonymous id will be allocated automatically. You have been warned.

2. Creating charts from database records.

3. Archive Database

4. I don′t see the tables in Data Director

5. How to Archive database

6. How do I create a recordset from and existing recordset

7. Archive-database

8. SQL Server Error Message

9. Archive Database

10. I can not Archive Database - Error in Repository.

11. Restoring Archived Database

12. Error when trying to archive database

13. archive database rights