Tuesday, March 24, 2015

SQL Server - Table backup.



     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'

No comments: