Backup - Solution Needed

[RLN]

hi group
My database name : developer
day 1. Taken full backup

day 2. taken differential backup

day 3. taken differential backup

day 4. taken differential backup

day 5. taken differential backup

day 6. taken differential backup
finished backups

month 1. after one month volunterily deleted records of tables.
month 2. want to view only database with day 2 .

( I want to restore only day2 backup (including full backup) and use
the database)

Is it possible in Microsoft SQL Server?

Need Good solution or tool for this.

Expecting good suggestions or coding or tools


With Admiration
RLN

[Simon Hayes]

I'm not sure what you're asking - do you want to know how to set up a
backup schedule like the one you've described, or do you want to know
how to recover your database back to day 2?

To create a backup schedule, you can use Enterprise Manager -
right-click the database, All Tasks, Backup Database, and select the
backup type and schedule details that you want. In this case, you would
need two backups - full scheduled once a week, and differential
scheduled each day.

To recover to day 2, you would need to recover the full backup from day
1 WITH NO RECOVERY, then the differential backup from day 2 WITH
RECOVERY.

If this doesn't help, I suggest you explain a bit more about what you
want to do, and it would also be useful to know which version of MSSQL
you have. There is lots of information in Books Online about backups
and recovery, and scheduled jobs, so you should have a look there also.

Simon

[RLN]

Is it possible to take backup for the particular date range?

for example
my database is fully up on year 2004.
i need seperate backups for every month ( total 12)
but i need to restore the data for only for the month of april 2004 i
don`t need previous to april and after april
Only restore april month.

[Simon Hayes]

Short answer - no. You can't back up individual pieces of data like
that, as it depends on what your data represents, how you've stored it,
how you identify data in each time period etc. Perhaps you can use
views to present each period of data to your clients, or you could
create multiple databases, then delete the unwanted data from each one
and back it up. But I have no idea if that makes any sense, and it
might be impractical with a large or complex database anyway.

If you need more suggestions, you should probably explain what your
goal is, and not how you want to achieve it, ie. don't tell us you want
12 separate backups, tell us why you think you need them. Someone may
be able to make a better suggestion with more information.

Simon