[Guide]Restore a table without restoring the whole database 10/11/2016 - SRO Private Server - 3 Replies In playing with my test server I've fucked up a few times as I'm sure some of you have as well.
Here's how you can restore an entire table or only parts of a table without restoring the entire database.
This is best used on _Ref<X> tables, tables that are only ever changed if you do it yourself. Dynamic tables like _Items or _Char are subject to problems if you use this kind of query and I don't recommend it and won't help you if you do it and something breaks.
:rtfm: First :rtfm:
...
Table restore 08/16/2012 - SRO Private Server - 3 Replies is there any option in sql 2008 r2 to restore a table only not a hole db ?
because i have my RefObjCommon table got fucked up . so i want to delete it and copy new lines but i cant delete it . it gives an error .
(cannot truncate table Refobjcommon because it is being referenced by a FOREIGN KEY constraint
How To Restore Table In SQL 07/15/2012 - SRO Private Server - 0 Replies Thread Is Shown From Subject Now Any One Know Pls Tell Me:confused: