471,091 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,091 software developers and data experts.

SQL Server Backup

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.

Jul 23 '05 #1
2 956
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

Jul 23 '05 #2
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.


Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by nt | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.