Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Location
    Madurai
    Posts
    3

    Post Unanswered: sqlserver , restore , Backup

    Hi,
    I want to check the database before restore (.Bak file).
    Chk the current database tables Vs tht backup file..
    Is it possible..

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Depends what you mean by "check". Also the format of your file affects your options.
    Most technically simple is restore the backup under a differently named database and run whatever checks you need.
    If it is a native backup, or is one supported by the respective vendors, then several vendors supply software that allows you to link to a backup file and access it like a normal database without actually restoring it. Again, you can apply your tests
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Aug 2010
    Location
    Madurai
    Posts
    3
    thanks Flump...
    Check Means ..
    I want to compare the current db table structure Vs Already backup file..
    If any changes means i dont want to restore ..
    else I want to restore the db

    I hope u understand..

    Thanks

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Restore with a different name and run SQLCompare (red-gate) or VS2008.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Tags for this Thread

Posting Permissions

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