resoring database from the backup

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)

resoring database from the backup

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-19 : 07:45:09

putane writes "Hi

we will take full backup on monday at 9.00 p.m,
differential backup everyday from tuesaday to sunday and transactional backup every 2 hour from 8.00 a.m to 8.00p.m
if the datbase crashes on friday at 6.30 p.m, whar are the backups i have to restore.

PLEASE GIVE ME SUGGESTIONS.

REGARDS
P.M.Sanjay"

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-10-19 : 08:03:21

Hi
You should restore the fullbackup first.and then the last differential backup and then everytransaction log backup in sequence

Regards
Nitin

dewacorp.alliances

452 Posts

Posted - 2006-10-19 : 11:31:25

To clarify what Nitin said.

Restore full backup on Monday.
Restore differential on Thursday.
Restore transactional on Friday - 8AM till 6PM.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources