Can we have a table backup scheduled

Question

I want to take a backup of a table in my database for every 2hrs is it possible?

I have a backup table in my database which holds the values from a different table

I wanted to know whether I can schedule this backup for every two hours

I dont need a full database back up i need just a table

possible duplicate of [table level backup](http://stackoverflow.com/questions/680552/table-level-backup) — billinkc, Jul 24 '13 at 18:51

score 2 · Accepted Answer · answered Jul 24 '13 at 18:17

2

You can move the table into its own filegroup and backup just that filegroup. This article describes how to back up a single file or filegroup.

answered Jul 24 '13 at 18:17

JAQFrost

score 0 · Answer 2 · edited May 23 '17 at 10:33

0

You can backup the whole database using the method outlined in this post: how to schedule backup in sql server 2008?

edited May 23 '17 at 10:33

Community

answered Jul 24 '13 at 18:12

mwhobrey

I dont need a full database backup i need just a table backup – Illuminati Jul 24 '13 at 18:13

2 Answers2