Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    Unanswered: archived data retrieval

    i need an archiving solution for a large retail store whose db is truncated after 6 months coz of it's massive size.How best can i obtain reports from the archived data. Do i use a linked server or what solution do you propose?

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    If you need to run adhoc reports on the archived data then you cannot archive it, unless by archive you mean onto another SQL Server. If you know already what reports you will be running then save the report data before archiving your data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts