Database type – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 290

Advertising
background image

SQL Server database status

Commands

Read-only,
offline, and
uncon-
firmed

Read-only
and uncon-
firmed

Read-only
and offline

Reading
and uncon-
firmed

Offline and
uncon-
firmed

No

No

No

No

No

drmsqlrecovertool

(when the Standby option is
specified)

No

No

No

No

No

drmsqlrecovertool

(when the Online option is
specified)

Yes (DB)

#

(becomes

read-only)

Yes (DB)

#

(becomes

read-only)

Yes (DB)

(becomes

read-only)

Yes (DB)

#

(becomes

read-only)

Yes (DB)

#

(becomes

read-only)

drmsqlrestore

(when the

-undo

option is

specified)

Yes (DB)

#

(becomes

reading)

Yes (DB)

#

(becomes

reading)

Yes (DB)

(becomes

reading)

Yes (DB)

#

(becomes

reading)

Yes (DB)

#

(becomes

reading)

drmsqlrestore

(when the

-undo

option is not

specified)

Legend:

Yes (DB): The command can be executed and the operations are performed on the database.
The database status after the operations is displayed in parenthesis.
Yes: The command can be executed; however, no operation is performed on the database.
No: The command cannot be executed.

#

If the database is in the

unconfirmed

status, it will be deleted and then restored automatically.

Database type

Table 100 Relationship between the type of the sql server database and executable commands

SQL Server database type

Commands

User database

System database

tempdb

model

msdb

master

Yes (DB)

--

Yes (DB)

Yes (DB)

Yes (DB)

drmsqlbackup

Yes

Yes

Yes

Yes

Yes

drmsqlcat

Yes

Yes

Yes

Yes

Yes

drmsqldisplay

Yes

Yes

Yes

Yes

Yes

drmsqlinit

Yes (DB)

#2

No

(No

operation is

performed)

#1

No

(No

operation is

performed)

#1

No

(No

operation is

performed)

#1

No

(No

operation is

performed)

#1

drmsqllogbackup

Operation for SQL Server databases

290

Advertising