January 18, 2012 at 12:21 am
one database i have 200 tables are there..
in that 200 tables i have to take the only " 1 table backup" i need
how to do
just tel me the command
January 18, 2012 at 1:35 am
There is no way to back up a single table.
You could take a "logical backup" exporting the data to a flat file using BCP or SSIS, but it's a whole different thing.
Hope this helps
Gianluca
-- Gianluca Sartori
January 18, 2012 at 2:06 am
jsut create one empty database and then copy the table that you want using the select into statement.
January 18, 2012 at 4:36 am
If the table is small. U can generate a script to create the table with the data.
For SQL Server 2008 R2 follow the steps:
1. Right Click on the database
2. Go to Tasks
3. Go to Generate Scripts option
4. Choose the Table to be backed up.
5. In the Advanced option , U need to select "Schema and data" for Types of data to script.
6. Save it to a SQL file.
For SQL Server 2008 there will be slight changes in the above process.
January 18, 2012 at 7:39 am
Nice,never new this was possible.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply