Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:00 PM
Points: 4,175, Visits: 4,257
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: Yesterday @ 11:50 AM
Points: 12,877, Visits: 31,792
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1438928
Posted Thursday, April 4, 2013 11:27 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:00 PM
Points: 4,175, Visits: 4,257
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