SQL Server 2005 backup

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
erupt
Forum Commoner
Posts: 58
Joined: Sat Feb 25, 2006 10:24 am

SQL Server 2005 backup

Post 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.
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post 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.
Post Reply