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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-08 : 09:01:53
|
| Sing Boon writes "I would like to do a backup on a particular table in a database, not the whole database, how can I do that? And how to perform the restore of table after that ?Thanks." |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-08 : 09:30:08
|
| You can't back up just one table. You could:1. Create a new blank database2. Copy the table across3. Backup and delete the databaseOr you could always drop the table into a text file using BCP |
 |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-09-09 : 00:52:41
|
| In order to be able to back up a single table, that table should be on a seperate file group. This file group can then be backed up independently.Hemanth GorijalaBI Architect / DBA |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-09 : 01:28:09
|
| I stand corrected..... |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-09-09 : 14:24:42
|
| you stand "sort of" corrected. Filegroup backups, I have found, are largely a pain in the ass. |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2004-09-09 : 14:36:40
|
| Depends on the version of SQLServer....If i remember correctly I think in SQL 6.5 you could back up and restore a single table.~ monkey |
|
|
|
|
|
|
How to perform backup on individual table in SQL server