Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Is it possible to to take the singetable backup

Author  Topic 

boreddy
Posting Yak Master

172 Posts

Posted - 2009-05-12 : 01:35:52
Hi exports
in my database i have many tables i want to take backup only one table is it possible
please explain
Thanks in advance

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-05-12 : 01:42:38
u can take the insert scripts for that single table with identity_insert on
Go to Top of Page

boreddy
Posting Yak Master

172 Posts

Posted - 2009-05-12 : 01:45:49
it is not possible to take backup and restore to single table
Go to Top of Page

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-05-12 : 01:49:57
i think it will not possible to take backup and restore the single table.....
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-05-12 : 01:49:58
I have already given feedback and vote for it
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=429541

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -