How To Take Backup and Restore For Single Table
Follow below steps for backup and restore a individual tables.
Step 1: Right Click on database then select Tasks then after select Generate Scripts
Step 1: Right Click on database then select Tasks then after select Generate Scripts
Step 2: Now popup window will open click Next
Step 3: Then Select the Required Database and click Next
Step 4: Then Choose script options window will open
Step 5: From table/view options select the script data option set to True from False and Click Next
Step 6: Now Select Tables and Click Next
Step 7: Now Select the Table Name and Click Finish
Finally you can have the table structure coding along with the data.
No comments:
Post a Comment