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)
 incomplete recovery

Author  Topic 

bobanjayan
Yak Posting Veteran

67 Posts

Posted - 2004-04-06 : 06:38:28
Is there any possible way for incomplete recovery.
i.e, Point in time recovery.

Boban
OCP - DBA 8i & 9i.
New in MSSQL.

MuadDBA

628 Posts

Posted - 2004-04-06 : 08:10:10
Yes there is.
Go to Top of Page

bobanjayan
Yak Posting Veteran

67 Posts

Posted - 2004-04-06 : 08:52:19
Thanx.
Let me find out.

Boban
OCP - DBA 8i & 9i.
New in MSSQL.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-04-06 : 12:24:11
You need the transaction log that occurred after the failure though. If you don't have that, you can only restore up to your last full backup, transaction log or differential backup, depending upon which one occurred last.

Tara
Go to Top of Page
   

- Advertisement -