SQL Server Recovery Status

Question

When restoring a SQL Server database, I notice that there are 3 different recovery states:

• Recovery Using Recovery
• Recovery without recovery
• Standby Recovery

I always left it by default, but what do they mean?

(Preferably in unprofessional terms)

Answer 1

GateKiller,

In simple terms (not a copy-extract from SQLBOL) so you can understand the concepts:

(, fulldata.bak) , . . , , - , .

(, - ), , , RESTORE NORECOVERY. ( ).

RECOVERY WITH STANDBY - (, NORECOVERY ), - READONLY. , ( ). , , , . (.. , 16 , 15 ).

, " " .

Answer 2

Microsoft SQL Server NORECOVERY, RECOVERY STANDBY.

RECOVERY - , ( , ).

NORECOVERY , . , .

STANDBY NORECOVERY, READONLY. , SELECT . . , , SQL Server, DBA . , , , .

Answer 3

, , ,

NORECOVERY

, . NORECOVERY STANDBY , . NORECOVERY, RECOVERY, STANDBY, RECOVERY .

SQL Server , WITH NORECOVERY , RESTORE, RESTORE (, , ).

. NORECOVERY , .

NORECOVERY . :

script, .

, .

, . .

RESTORE (RESTORE LOG RESTORE DATABASE ), NORECOVERY STANDBY.

NORECOVERY, RECOVERY, STANDBY, RECOVERY . SQL Server . , WITH RECOVERY. . .

STANDBY= undo_file_name

, . , , , . NORECOVERY, RECOVERY, STANDBY, RECOVERY .

STANDBY , , .

, SQL Server . , SQL Server .

undo . . .

. , , , .

STANDBY .