With Standby UNDO - 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)

With Standby UNDO

Author

Topic

sureshot
Yak Posting Veteran

72 Posts

Posted - 2007-02-09 : 19:16:28

I'm confused how the undo works when you restore WITH STANDBY

Suppose I restore WITH STANDBY

FULL
DIFF
LOG A
LOG B
LOG C

How do I undo LOG C? Do I restore LOG B again?

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-02-09 : 20:04:40

Start from the beginning:
FULL
DIFF
LOG A
LOG B

CODO ERGO SUM

sureshot
Yak Posting Veteran

72 Posts

Posted - 2007-02-10 : 02:17:30

That's not much of an undo. Why is it called an undo file and what is it for?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources