Backup a Single Table in SQL Server using SSMS

re: Backup a Single Table in SQL Server using SSMS

cany — Wed, 09 Jun 2010 18:45:09 GMT

Hi,

Why I can not see 'Advanced' button in step

4. In the Set Scripting Options pane, click Advanced ?

Thanks.

re: Backup a Single Table in SQL Server using SSMS

Uzzie — Fri, 11 Jun 2010 01:58:12 GMT

Hi Cany,

If you are using SSMS 2008, steps that you need:

- Right click on the DB

- Choose "Tasks" and then "Generate Scripts" and "Script Wizard" dialog box will appear. Then click NEXT.

- Choose DB (don't know why it ask you again?? :P) and NEXT.

- You are at "Choose Script Options" page now. Scroll down to "Table/View Options" and you'll see "Script Data". Set to TRUE if you want to backup the data in the table too. You can also choose other options as you wish. Hit NEXT.

- Select object you want to script.

- Follow the rest of the instruction.

Cheers,

Uzzie

re: Backup a Single Table in SQL Server using SSMS

Deepika — Fri, 05 Aug 2011 09:32:09 GMT

Helpful!!!Thanks:)

re: Backup a Single Table in SQL Server using SSMS

Mahant — Tue, 09 Aug 2011 16:56:14 GMT

Thanks, it helped.

re: Backup a Single Table in SQL Server using SSMS

Hammad — Fri, 14 Oct 2011 20:36:55 GMT

Does not work in MSSQL Management Studio 2005. It scripts only structure and schema no data.

re: Backup a Single Table in SQL Server using SSMS

Meesham — Tue, 10 Apr 2012 00:05:16 GMT

Thanks a lot. It helped me take my table backups!

re: Backup a Single Table in SQL Server using SSMS

Ajit — Fri, 04 May 2012 10:21:47 GMT

Is there any query to take bakcup of table and database.

re: Backup a Single Table in SQL Server using SSMS

Dinesh Vishe — Thu, 28 Jun 2012 06:53:01 GMT

if i want take backup 3-4 table then please suggest

re: Backup a Single Table in SQL Server using SSMS

Greg Low — Thu, 28 Jun 2012 07:23:13 GMT

You can just script those 3 tables.

re: Backup a Single Table in SQL Server using SSMS

Aravindh — Thu, 28 Jun 2012 07:24:55 GMT

It should not be work in mysql 2000

re: Backup a Single Table in SQL Server using SSMS

Greg Low — Thu, 28 Jun 2012 08:54:46 GMT

I can't comment on mysql

re: Backup a Single Table in SQL Server using SSMS

Greg Low — Sat, 14 Jul 2012 07:04:59 GMT

Have you considered using Integration Services? That's the type of repetitive task that it's designed to do.

re: Backup a Single Table in SQL Server using SSMS

Sunil — Fri, 20 Jul 2012 15:21:21 GMT

Hi Greg

i am using Sql azure where Integration Services is not available

Thanks

re: Backup a Single Table in SQL Server using SSMS

Greg Low — Fri, 20 Jul 2012 23:31:58 GMT

Hi Sunil,

Yes, but a local copy of Integration Services can connect to SQL Azure just the same. Or are you trying to copy the table to Azure storage or something? (And is it large?)

Regards,

Greg

re: Backup a Single Table in SQL Server using SSMS

senthilsjc — Thu, 13 Dec 2012 16:48:01 GMT

we can use this method for small size of table only

re: Backup a Single Table in SQL Server using SSMS

pavan — Fri, 28 Dec 2012 08:03:43 GMT

how to retrieve table information

re: Backup a Single Table in SQL Server using SSMS

sathish — Sun, 24 Feb 2013 23:38:54 GMT

hey man i tried this but the script generated was to create table is it like after generating script should i change the command to backup and run!!!!!! pls advise...

re: Backup a Single Table in SQL Server using SSMS

Greg Low — Mon, 25 Feb 2013 00:10:13 GMT

Sorry, don't follow. There are scripting options for creating (or dropping) the table, and/or for including the data when generating the script. This is just a way of scripting a table with it's data in it. You then need to use the script that's generated on another DB.

re: Backup a Single Table in SQL Server using SSMS

ashwini — Thu, 11 Apr 2013 05:42:11 GMT

Guys in MSSQL 5 use

select * into NewTableName from ExistingTableName

make sure NewTableName is not available in DB and ExistingTableName is already available in DB.

This query create a new table with schema of existing table as well as dump complete data.

re: Backup a Single Table in SQL Server using SSMS

Greg Low — Fri, 26 Apr 2013 01:14:10 GMT

Hi Ashwini,

That creates a new table with the same contents of the old one, not a backup of the table. (Backups can be taken elsewhere).