Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup Solution Needed

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-23 : 08:21:03
Lakshmi Narasimman writes "Please provide the solution for the following:


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"

Kristen
Test

22859 Posts

Posted - 2005-02-23 : 09:08:19
Restore the day 1 full backup, followed by the day 2 differential backup.

or maybe I'm misunderstanding the question?

Kristen
Go to Top of Page
   

- Advertisement -