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
RLNI'm not sure what you want to accomplish. Are you saying that you want to re
store the database as it
were at a certain point in time? If so, then you need to look into doing tra
nsaction 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 o
f
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN

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

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
Not as a backup. You would have to write something to extract the data you
want.
Andrew J. Kelly SQL MVP
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:9BD84D1A-ACC2-4680-BEE2-A41EC04E67B2@.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