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 |
|
sohrab
Starting Member
3 Posts |
 Posted - 2006-01-30 : 18:00:11
|
| Is it possible to do object level backup in MSSQL?For example make a backup of only one table.Any tools?Thanks in advance for your comments. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-30 : 18:03:09
|
| You can't do this with the BACKUP/RESTORE commands. However, you can perform a backup of a table by bcp'ing out the data to a file, generating the schema script and putting that into source control, SELECT * INTO BackupTableName FROM TableName, and various other ways. It just depends what the backup is intended for. Let us know and we'll point you down the right path.Tara Kizeraka tduggan |
 |
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
|
|
|
Object level backup and restore