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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2008-03-10 : 06:20:37
|
| GurusPlease let me know how do i backup a single table in sql server,i don't want to back up a file group or some thing nor i want to export a table..I was told that if you have a PK on the table you can backup the clustered index or something.I don't have a clear idea,Please adviceRegardsNitin |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-10 : 09:50:39
|
| It's impossible in SQL Server 2000. It was possible in SQL 6.5. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-10 : 12:04:22
|
you could export the table to a csv using BCP or similar.
elsasoft.org |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-10 : 22:29:18
|
| >> i don't want to back up a file group or some thing nor i want to export a tableSo you like to do something sql doesn't supported? Good luck. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-11 : 00:20:45
|
| Here's what I do:SELECT * INTO Table1_Backup FROM Table1Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2008-03-11 : 10:23:15
|
| Thanks Tara/EverybodySelect * into new table from oldtable is fine,but i was told in the interview that there is one more optionThanks a lot everybody for your helpRegardsNitin |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-11 : 10:29:12
|
| "Select * into new table from oldtable is fine,but i was told in the interview that there is one more option"What? I think interviewer needs to study books for SQL 2000. |
|
|
|
|
|
|
How to backup a single table