sql method !!

i wanna drop a one single table from shard db and restore it from old backup

explain : got some problems in Refskill & i wanna replace this table only with the refskill in the old backup

btw : about 3 ~ 4 days searching in sql methods in google and i cant do it


any hints ? or some help ?

Regards

restore ur old backup with a different name and use this query

Quote:

use CURRENT_SHARD_NAME drop table _RefSkill select * into CURRENT_SHARD_NAME.dbo._RefSkill from OLD_BACKUP_NAME.dbo._RefSkill

i saved it , i will try it later & give you a feedback for sure !!