Backup a single table with its data from a database in sql server 2008

by 
SELECT * INTO mytable_backup FROM mytable

This makes a copy of table mytable, and every row in it, called mytable_backup. It will not copy any indices, constraints, etc., just the structure and data.

Note that this will not work if you have an existing table named mytable_backup, so if you want to use this code regularly (for example, to backup daily or monthly), you’ll need to run drop mytable_backup first.

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. T-SQL split string
  3. How can I get column names from a table in SQL Server?
  4. Conditional WHERE clause in SQL Server
  5. How can I select the first day of a month in SQL?
  6. GROUP BY to combine/concat a column [duplicate]
  7. Select statement to find duplicates on certain fields
  8. How to set table name in dynamic SQL query?
  9. Using a Variable in OPENROWSET Query
  10. How to find current transaction level?
  11. EXISTS vs JOIN and use of EXISTS clause
  12. Check for file exists or not in sql server?
  13. Group DateTime into 5,15,30 and 60 minute intervals
  14. Why is a UDF so much slower than a subquery?
  15. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  16. UNIX_TIMESTAMP in SQL Server
  17. Which SQL query is faster? Filter on Join criteria or Where clause?
  18. UPDATE and REPLACE part of a string
  19. Improve SQL Server query performance on large tables
  20. Add emoji / emoticon to SQL Server table
  21. SQL Server SELECT INTO @variable?
  22. How do I change db schema to dbo
  23. How to subtract 30 days from the current date using SQL Server
  24. How do I find the data directory for a SQL Server instance?
  25. Count records for every month in a year
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment