July 24, 2015 at 2:07 am
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
July 24, 2015 at 2:40 am
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 http://sqlblog.com/blogs/greg_low/archive/2010/06/07/backup-a-single-table-in-sql-server-using-ssms.aspx and http://sqlbak.com/blog/how-to-backup-a-table-in-sql-server/ Hope this will be useful
July 24, 2015 at 3:54 am
if it is just data, no idexes etc
select * into newtable from oldtable
you can use generate scripts via the GUI to script out the table and objects if required.
July 24, 2015 at 7:39 am
You can also BCP out
July 24, 2015 at 7:55 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply