Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

backup a table 1

Status
Not open for further replies.

brownjms34

Programmer
Jul 24, 2015
1
UA
Hello, can you help me? I need to backup a single table in SQL server. I use SQL Server 2008 r2 and this is new for me
 
I would suggest two way to you. Which you will choose depend on the reason why you want to backup a table. If you need just the data and you want it locally (on the same database/server) then you can use the first option, through T-SQL scripts. If you need to back up the table to prevent data loss for a disaster situation, there is oppotunity to use SSMS. Probably second way is more easy. There are few articles, you can find more details if you need and Hope this will be useful
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top