Hi My db is prob - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Hi My db is prob

Author

Topic

siva.meti
Starting Member

32 Posts

Posted - 2007-08-29 : 12:53:51

Hi friends,

My database had this require ment

Every day my database 12;00pm we will take fullbackup
1:00 O clock differntial backup
2:00 O clok again on diifferntial backup
Every 15(fifteen)Min we will take Transaction log backups
My database is crashed on 2:00 clock we will not take 2:00 clock Tlog backup
we have taken only 1:45 Tlog backup.

Here my database is loss 1:45 to 2:00 clock data

we cannot take this 15min Tlog backup

Any body plz give suggestion on how to recover this 15min data plz help me it very urgent

Regurds
subu

Meti BEST OF THE BEST

Kristen
Test

22859 Posts

Posted - 2007-08-29 : 14:16:28

What sort of crash at 2:00?

Usually you can still make a TLog backup after a crash, and then restore to point-in-time, using that Tlog backup, to just before the crash.

I don't know why you are taking a DIFF backup every hour, but that's unusual and probably quite a lot of "strain" for your system.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources