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 |
|
dass05555
Yak Posting Veteran
55 Posts |
 Posted - 2008-03-17 : 08:16:11
|
| dear db gurus, can you help me how to get back up for the table in a database...regardsdass |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-03-17 : 08:26:54
|
| You can make a copy of it by select * into NewTable from OldTableBut for a backup just backup the whole database."God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-03-17 : 09:02:47
|
| 1 Script the table2 bcp data to text fileMadhivananFailing to plan is Planning to fail |
|
|
|
PABluesMan
Starting Member
26 Posts |
Posted - 2008-03-24 : 16:02:52
|
| Another option is to use a third-party product like LiteSpeed for SQL. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 22:30:01
|
| Litespeed can restore a table but not backup a table. Only way to backup table is put it in separate filegroup then backup that filegroup. |
|
|
|
|
|
|
Back up table