Hp XP Command View Advanced Edition Software User Manual Page 398

  • Download
  • Add to my manuals
  • Print
  • Page
    / 580
  • Table of contents
  • TROUBLESHOOTING
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 397
1. Back up the user database.
On the database server (active server), execute the drmsqlbackup command with the -target
or -f option specified.
To execute the drmsqlbackup command with the -target option specified:
PROMPT> drmsqlbackup instance-name -target user-database-name
To execute the drmsqlbackup command with the -f option specified:
PROMPT> drmsqlbackup instance-name -f target-definition-file-name
2. Back up the user database transaction logs.
On the database server (active server), execute the drmsqllogbackup command.
PROMPT> drmsqllogbackup instance-name
3. Use a tool such as SQL Server Management Studio to delete the AlwaysOn availability group
configuration for the database server (active server).
4. Restore the user database.
On the database server (active server), execute the drmsqlrestore command.
PROMPT> drmsqlrestore backup-ID -resync -target user-database-name
5. Recover the SQL Server database.
On the database server (active server), execute the drmsqlrecover or drmsqlrecovertool
command.
To execute the drmsqlrecover command for recovery:
PROMPT> drmsqlrecover instance-name
To execute the drmsqlrecovertool command for recovery:
PROMPT> drmsqlrecovertool instance-name
6. Use a tool such as SQL Server Management Studio to create the AlwaysOn availability group
configuration for the database server (active server).
Restoring a user database to the standby server from the active server
To restore a user database to the standby server from the active server:
Operation for SQL Server databases398
Page view 397
1 2 ... 393 394 395 396 397 398 399 400 401 402 403 ... 579 580

Comments to this Manuals

No comments