Tuesday, March 6, 2012

How to take backup & restore for one table?

We can take backup of table with schema and data.

Right Click on database
-Tasks
-Generate Scripts
-select a database
-Choose script options
select the script data option set to Schema and data only
-and proceed further....

No comments:

Post a Comment