sql method !!

[Eslam Galull]

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

[Aaron*]

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

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

[Eslam Galull]

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