SQL Server Table Backup

[RLN]

Anybody know how to backup a table with particular range.

Ex one column contains date..

I need to backup only data belong from date to date.
is is possible via programming in C?

if yes give example ( don`t tell backup SQL command)

RLN

[David Portas]

You can't selectively backup rows using SQL BACKUP. What you could do
is copy the required data to another database and then back that up:

INSERT INTO BackupDB.dbo.YourTable (col1, col2, ...)
SELECT col1, col2, ...
FROM YourDB.dbo.YourTable
WHERE date_col >= '20040101'
AND date_col < '20050101'

You can drive this based on the current date for example and then use
it as a regular archiving process.

--
David Portas
SQL Server MVP
--

[Greg D. Moore \(Strider\)]

"David Portas" <RE****************************@acm.org> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

You can't selectively backup rows using SQL BACKUP. What you could do
is copy the required data to another database and then back that up:

INSERT INTO BackupDB.dbo.YourTable (col1, col2, ...)
SELECT col1, col2, ...
FROM YourDB.dbo.YourTable
WHERE date_col >= '20040101'
AND date_col < '20050101'

You can drive this based on the current date for example and then use
it as a regular archiving process.
Another idea is to use BCP with that sort of select statement to dump the
table contents to a file that can be backed up separately.


--
David Portas
SQL Server MVP
--