Tuesday, May 4, 2010

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 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.
Single table restore from backup. table backup and restore. how to do table restore from backup file. how to take single table backup. how to restore single table from old backup file. What are the types of backups in sql server 2008 R2. What are the types of backups in sql server 2012. What are the types of backups in sql server 2005. how many types of backups in sql server 2008.   how many types of backups in sql server 2012. how many types of backups in sql server 2008 R2. how many types of backups in sql server 2005. how many types of restores in sql server 2008. how many types of restores in sql server 2012. how many types of restores in sql server 2005.

1 comments:

Hi Naresh,
I read couple of blogs as most of them are excellent.
And couple of them like this post,
It would be great, If you just mention some where in the blog as its only holds limited size of the table...
I m positive I had done this before(with SQL 2008) and couldn't hold whole table as its size is way bigger.(I am not sure in the latest versions.)

Please update If you have any latest news on this.
Thanks,
Praveen Synick.

Post a Comment