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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2007-02-07 : 07:01:54
|
| I have heard on the grapevine that you can now backup specific tables in SQL Server 2005. However, I cannot find anything in BOL (or am using the wrong search criteria). Can anybody verify whether this is just a viscious rumour or it can be in fact done. If the latter, then how or provide a link to the information in msdn or wherever.ThankyouHearty head pats |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-07 : 07:19:05
|
| I don't think backing specific tables in SQL 2005 is possible in direct way. However, you can place some frequently used tables on some filegroup and back up only that specific filegroup.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2007-02-07 : 07:46:40
|
| Thought it was too good to be true.Thankyou, I shall try that method instead.Hearty head pats |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-07 : 09:29:47
|
| LiteSpeedBackup (SP?) has that ablity I thinkKristen |
|
|
|
|
|
|
Backup and Restore tables