SQL Server Data Archive Solution -

I am looking for a solution to the archive data contained in my database. My database is SQL Server 2008 and approximately 250 tables I search the web and look for the link below:

But this solution is not clear

I do not know that this is a direct way of doing SQL Server Give me a solution.

The solution you choose will depend on your reasons for applying it, for example, To consider:

1. Which data is to be stored?

   For example, older data or data from a certain date?

   There is an implication for the most appropriate collection techniques to use, i.e. a complete database backup may be adequate or perhaps it can be used to store a record more suitable.

2. How accessible should the archived data be?

   Should the stored data be immediately available, perhaps acceptable for slow SATA storage or perhaps access to data for a period of several days? Perhaps if the time of restoring is quite generous then a complete database backup is taken at regular intervals, once in a month it can say that it is enough. If on the other hand the data is kept in a lot of hands, then the solution is solved.

3. What are the security implications for data?

   For example, should backups be encrypted or if the data is being processed, is there enough physical security?

Perhaps if you can provide some more details about your reasons for wanting to store your data and also how much data you want in your collection , We can provide more specific guidance.