Help in Table level restore/backup Options

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FARRUKH - 30 Apr 2008 21:19 GMT

I am currently doing a project on MS SQL Server 2005 where I am in
need of table level backup/restore. I know about FILEGROUP. But in
our project using FILEGROUP is not feasible. As far as I know MS SQL
Server 2005 does not support Table level restore directly.

Is there any clever trick or 3rd party software to do table level
restore/backup? Please Help. Is there any Microsoft article that shows
clearly that SQL Server only take full database, transactional and file group
backup? i want to show management so they belive me

thanks

Best regards
Nasif

Reply to this Message

Tom Moreau - 30 Apr 2008 21:22 GMT

The BOL does not mention a table-level backup, so that should be proof
enough. One alternative would be to bcp out the table to a file and then
bcp it back as required.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

I am currently doing a project on MS SQL Server 2005 where I am in
need of table level backup/restore. I know about FILEGROUP. But in
our project using FILEGROUP is not feasible. As far as I know MS SQL
Server 2005 does not support Table level restore directly.

Is there any clever trick or 3rd party software to do table level
restore/backup? Please Help. Is there any Microsoft article that shows
clearly that SQL Server only take full database, transactional and file
group
backup? i want to show management so they belive me

thanks

Best regards
Nasif

Reply to this Message

TheSQLGuru - 30 Apr 2008 23:11 GMT

Hyperbac and LiteSpeed both offer table-level restores IIRC.

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

>I am currently doing a project on MS SQL Server 2005 where I am in
> need of table level backup/restore. I know about FILEGROUP. But in
[quoted text clipped - 11 lines]
> Best regards
> Nasif

Reply to this Message