SEO

#1 (**permalink**) 02-29-2008, 06:12 AM

Is it possible to take backup of database for 1 day change?

also possible to restore it back for the particular date?

for example..

In one month data of database I want to take a backup for changes in
13 of the month.
if required restore it back.

#2 (**permalink**) 02-29-2008, 06:12 AM

If you use transaction log backups you can *restore* changes up to a
particular date but a backup of a database or log always includes all
committed data at the point of backup. If you require a greater degree
of selectivity you can restore to a temporary database and then extract
just the required data.

--
David Portas
SQL Server MVP
--

#3 (**permalink**) 02-29-2008, 06:12 AM

In addition to David's response, there are also differential backups,
which can reduce the number of restores needed to get back to a certain
point. For example, you can do a full backup once a week (eg. Sunday),
a differential once a day, and log backups every hour. Then to get back
to Tuesday, you would restore only Sunday's full backup and Tuesday's
differential, rather than Sunday's full backup and all the log backups
from Monday and Tuesday. See "Reducing Recovery Time" in Books Online
for more details.

Check out the "Backing Up and Restoring Databases" section in Books
Online - there's lots of good information there.

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL Server Backup