Partial Backup

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  December 4, 2008 at 9:13 am

  #196864

  Hi All,

  I'm pretty sure this isn't possible.

  But can you run a back up on a database for only some tables?

  Or does a back up always do the whole DB?

  Otherwise is the best option to perhaps BCP the tables out that you want?

  Thanks

  Chris

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 4, 2008 at 9:33 am

  #907725

  The only way you can backup a single table is if that table is in a filegroup by itself. Then you can back up the filegroup.

  You can backup at the database level, the filegroup level or the file level.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• SQL_EXPAT

  SSCrazy

  Points: 2708

  More actions

  December 4, 2008 at 10:22 am

  #907772

  BCP them out. We do that daily filtered on day. works great for archiving. be sure to use native mode and create an fmt file too to assist you when you need to BCP them back in

  thanks

  SQL_EXPAT