Page 1 of 1

SQL Server 2005 backup

Posted: Wed Dec 27, 2006 10:40 am
by erupt
Using sql server 2005, is there a way to schedule a backup of a single table? I know of the ways to schedule backups of entire databases and i'd rather not move that particular table that needs backup to its own database and backup the database ..... so that's my basic question can it be done through point-and-click in sql server or would that call for a stored procedure? Any input would be awesome.

Posted: Wed Dec 27, 2006 11:21 am
by Burrito
I think you can do it with dts packages. I fooled around a bit with it last week and seems I remember seeing something about 'exporting' single tables.