Monday, April 04, 2011

SQL Server Table Level Backup

BACKUP DATABASE does not support table level backup.
1.you can use use SQL Server Management Studio to script it out.
right clicking Database > Tasks > Generate Script
2.you can use export function to export it into csv file
3.you can use bcp to do similar thing