Post reply

Restore table in sql server

  • April 4, 2013 at 11:20 am

    #276091

    hi guys,

    I know how to restore database in sql server but i wanted to know how to restore table in sql server 2000/2005/2008

    thnx...reply

  • April 4, 2013 at 11:23 am

    #1603660

    You will need a 3rd party tool such as NetVault LiteSpeed for SQL Server or Redgate SQL Backup Pro.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • April 4, 2013 at 11:24 am

    #1603662

    you restore the last good backup as a new database name.

    then you can use cross database queries move differences from one table to another;

    depending on the foreign keys, you might be prevented from just deleting the table and inserting again from the old, but the specifics would be unique to the tables and what data needs to be recovered(ie the table was deleted, vs transactions after 12 noon are missing, vs, bad data due to an update needs to be fixed, etc)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 4, 2013 at 11:27 am

    #1603666

    Lowell's suggestion is a good one and that is what I currently do because I do not have a 3rd party tool to do so due to the expense.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply