Thursday 29 September 2016

How to take a backUp of single table in SQL Server 2008R2?



Select  * into new_tabel_Name  from tablename

new_table_Name :- new table in which you want to store data(No need to create a table. It automatically create when you run the query)

tablename :- Existing table from which you want to take a back up

No comments:

Post a Comment

Note: only a member of this blog may post a comment.