So, my db can be in three differrent statuses.
And I want to know current db's status by query. Can you help me ? The single what I've found is
SELECT is_in_standby FROM sys.databases WHERE [name] = 'MyDb1'
MyDb1 is actually in
StandBy mode I'll give following:
is_in_standby ------------- 1
But Is there way to determine that
NoRecovery mode ?