MS SQL SERVER DBA

     Now we are going to see how we are going to take a table backup. Backup single table exec master .. xp_cmdshell 'BCP export1.dbo.tab1 out new.txt -c -U sa -P sa -S ION-0481AD1D360\SQLTEST' Restore from file to table exec master .. xp_cmdshell 'BCP export1.dbo.tab1 in new.txt -c -U sa -P sa -S ION-0481AD1D360\SQLTEST'