Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    14

    Question Unanswered: Querying a backup db

    I'm backing up a table every month (appending, full backup).
    But I need to query the backup for statistics...

    Is it possible to query a backup?


    thanks,

    gdo

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    If I understand correctly you want to select data directly from backup...
    It is impossible without restoring....

    You can get backup history from system tables (on msdb), restore selected backup with another name (history for example) and use it.

Posting Permissions

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