Question: How can I backup a single table with data in a database ? I need a quick method to save the data as I’d like to make changes to the original table, without backing up the whole database.
Answer: A simple method to backup the whole table is:
select * into dbo.new_table from dbo.old_table
For backup of specific Column Data in the table
select Col1, Col2 into dbo.new_table from dbo.old_table
To backup to an Excel spreadsheet – read SQL Server Export to Excel with Powershell