Tuesday, March 27, 2012

Backing up one db table

Is it possible to only backup one table in a SQL database, or do you
have to back up everything?
TIA,
-Ben
Bem
You can put the table on separate filegroup and then perfom backup of this
filegroup.
For more details please refer to the BOL.
"Ben" <bmilliron@.gmail.com> wrote in message
news:%23RG806QiEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Is it possible to only backup one table in a SQL database, or do you
> have to back up everything?
> TIA,
> -Ben
|||No, backup is not possible for a single table. The lowest level possible is
a single data file. If you need a single table backup, you have to do it
with ther tools, not backup. You can use Data Transformation Services, a
T-SQL query, bcp.exe...
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Ben" <bmilliron@.gmail.com> wrote in message
news:%23RG806QiEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Is it possible to only backup one table in a SQL database, or do you
> have to back up everything?
> TIA,
> -Ben
|||Just be aware that RESTORE might not be possible, they way the OP wants...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:OPrgM%23QiEHA.1276@.TK2MSFTNGP09.phx.gbl...
> Bem
> You can put the table on separate filegroup and then perfom backup of this
> filegroup.
> For more details please refer to the BOL.
>
> "Ben" <bmilliron@.gmail.com> wrote in message
> news:%23RG806QiEHA.3928@.TK2MSFTNGP11.phx.gbl...
>

No comments:

Post a Comment