tag:blogger.com,1999:blog-3682177839638728927.post6497963230122700854..comments2024-03-09T14:05:29.528+05:30Comments on SQL: How to restore single table from backupAnonymoushttp://www.blogger.com/profile/09453699184523060639noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3682177839638728927.post-62846568066832474712016-07-18T17:41:29.106+05:302016-07-18T17:41:29.106+05:30thanks Arun for leaving this up, you can also take...thanks Arun for leaving this up, you can also take the help of this link to know different methods to restore a single table in SQL Server: <a href="http://sqltechtips.blogspot.com/2016/01/restore-deleted-table-data-in-sql.html" rel="nofollow">http://sqltechtips.blogspot.com/2016/01/restore-deleted-table-data-in-sql.html</a> Anonymoushttps://www.blogger.com/profile/16743118529165366097noreply@blogger.comtag:blogger.com,1999:blog-3682177839638728927.post-22689625240841016542014-12-10T01:16:02.618+05:302014-12-10T01:16:02.618+05:30To export:
bcp "[MyDatabase].dbo.Customer&qu...<br />To export:<br /><br />bcp "[MyDatabase].dbo.Customer" out "Customer.bcp" -N -S ServerName -T -E -U"xxxxxx" -P"xxxxxxx"<br /><br /><br />To import:<br /><br />bcp "[MyDatabase].dbo.Customer" in "Customer.bcp" -N -S ServerName -T -E -b 10000 -U"xxxxxx" -P"xxxxxxx"<br />Anonymoushttps://www.blogger.com/profile/16207500064277233886noreply@blogger.comtag:blogger.com,1999:blog-3682177839638728927.post-49430695125922845292012-04-13T16:32:03.414+05:302012-04-13T16:32:03.414+05:30Thank you for sharing easy steps to restore corrup...Thank you for sharing easy steps to restore corrupt SQL table. But these steps will work only for single table restoration or if we have updated backup copy. If you want to recover full database mdf or ndf files then you can try <a href="http://www.stellarinfo.com/sql-recovery.htm" rel="nofollow">SQL Recovery Software</a>. The software recovers full database as well as single objects of the database.Anonymoushttps://www.blogger.com/profile/12599855307231336356noreply@blogger.com