Tuesday, February 14, 2012

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.
WM_QUIT
RLN
I'm not sure what you want to accomplish. Are you saying that you want to restore the database as it
were at a certain point in time? If so, then you need to look into doing transaction log backups, as
they give you the ability to perform point-in-time restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:77A5FB86-2765-4036-AA4A-4BA93CA767CB@.microsoft.com...
> 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.
>
> --
> WM_QUIT
> RLN

No comments:

Post a Comment