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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2006-12-11 : 14:17:07
|
Anyone have a clue on how to restore a single table using xp_restore_database or any of the other litespeed xps? One of the guys here said you have to configure litespeed to do "object level backups". Personally I think he just doesn't know what he's talking about; however, I have never done a single object restore with litespeed either. I'm guessing Tara will put her two cents in on this one  . Thanks for any help from anyone.Thanks,Daniel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-11 : 14:39:33
|
My $0.02  :Check out the "Object Level Recovery" topic in the Litespeed 2005 SQL Help documentation. That topic can be found in the Contents tab, Litespeed 2005 for SQL book.I've never used it, so I can't provide much more help on it.Tara Kizer |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2006-12-11 : 15:03:54
|
| Thanks for the info. That points me in the direction I should be going. There were two procs (xp_objectrecovery_viewcontents & xp_objectrecovery) listed but they don't exist in the same place as the other litespeed procs. I'll dig and see what I can find and let you know how it turns out.Thanks again. |
|
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2006-12-12 : 09:56:55
|
| The deal was that I'm running 4.0.98. The software is up to 4.6. Looks like I'll be upgrading soon.. Thanks |
|
|
|
|
|
|
Litespeed single table restore via ls xp?