SQL Server – Script to Backup a Single Table

  By ,

Script to backup a single table:

 

select * into newtablename from oldtablename

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL Server – Top Queries Consuming CPU
  2. SQL SERVER – Get Table Partition Information
  3. MySQL – Restore a Single Table from a FULL mysqldump file
  4. SQL Server – Reinitializing a Single Article In Transaction Replication
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *