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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2006-09-13 : 09:19:24
|
| Dear All,Is it possible to do the backup for a single table ..?Thanks And RegardsKrishnakumar.C |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-13 : 09:32:46
|
| You can copy it to another database and back that up or put it on it's own filegroup and back that up.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-14 : 07:43:20
|
| Or for a one-off to protect yourself from some operation you are about to do I use:SELECT * INTO TEMP_MyTableName_20060614 FROM MyTableNameI always use the "TEMP_" prefix, and I review them periodically and drop the ones which are sufficiently "stale"For a Production database I always create the TEMP_ table in a non-production database:SELECT * INTO WorkingDatabase.dbo.TEMP_MyTableName_20060614 FROM ProductionDatabase.dbo.MyTableNameKristen |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-14 : 08:13:13
|
| Reminds me that for v2005 you can use a database snapshot.Must try it sometime.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
anilkdanta
Starting Member
25 Posts |
Posted - 2006-09-21 : 07:05:54
|
| What is the reason behind taking backup for a single table ?You can export the data in that table to flat file(comma or tab separated values) or excel sheet, and save the file.Later you can import the data from the file to the table on any database. This serves the purpose of taking back up of a single table. |
|
|
|
|
|
|
Table Backup