Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
komali
Starting Member
4 Posts |
 Posted - 2007-07-31 : 04:33:40
|
| hi all, I have to take Back up only some tables containing one database..... is it possible? Thanks in advance |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 04:44:45
|
| no.you can either backup the whole db or export those table to a file using BCP._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
komali
Starting Member
4 Posts |
Posted - 2007-07-31 : 04:50:57
|
| ThanQ, May i know what is this BCP? plz explain in clear...... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-31 : 05:00:41
|
| BCP is a utility for Export and Import of data via external files.You can also use DTS which does the same thing, but directly between databases (or via other transport mechanisms, such as Files etc.)You could set up a LINKED SERVER and then standard SQL to Insert the rows into the remote server:INSERT INTO LinkedServer.RemoteDatabase.dbo.RemoteTableFROM dbo.LocalTableYou could also Backup the database, Restore somewhere else, and then DROP all the tables you didn't need.Kristen |
|
|
|
komali
Starting Member
4 Posts |
Posted - 2007-07-31 : 05:16:07
|
| ThanQ Mr.Kristen for u r reply....AS per my concern whatever the actions u mentioned all are indirect methods to backup the tables......So exactly There is no option for tables backup as one shoot right?ok thank you |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 05:27:27
|
| no there is none._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
komali
Starting Member
4 Posts |
Posted - 2007-07-31 : 05:33:10
|
| ok Thank you spirit1...... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-31 : 06:06:15
|
| "There is no option for tables backup as one shoot right?"Correct. But usually "Backup some tables" means to copy/transfer them to somewhere else, and the methods above will do that.If OTOH there are tables in your database that do NOT need to be backed up (or can be backed up separately on different schedules) you might be able to use filegroups for that purposeKristen |
|
|
|
|
|
|
Need to BackUp Only Some Tables