Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore table in sql server Expand / Collapse
Author
Message
Posted Thursday, April 4, 2013 11:20 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 21, 2014 12:41 PM
Points: 65, Visits: 234
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
Post #1438924
Posted Thursday, April 4, 2013 11:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 20, 2016 3:49 AM
Points: 5,002, Visits: 4,797
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/

Post #1438926
Posted Thursday, April 4, 2013 11:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 14,460, Visits: 37,994
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!
Post #1438928
Posted Thursday, April 4, 2013 11:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 20, 2016 3:49 AM
Points: 5,002, Visits: 4,797
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/

Post #1438932
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse