Moving standard SQL databases to the AlwaysOn node

Edit online

You can specify the /USEALWAYSONnode parameter with the backup command to back up standard SQL databases to the file space for the AlwaysOn node. This transition can make it easier for you to manage all your database backups under a single node name.

About this task

If you want to regularly back up standard SQL databases to the file space for the AlwaysOn node, you can use the set command.

The AlwaysOn node name is required when you configure IBM Storage Protect Snapshot with SQL Server 2012 and later versions. It is not necessary to specify the AlwaysOn node name during each backup, query, or restore operation of an availability database.

The AlwaysOn node does not affect where standard databases are backed up. The standard databases continue to be backed up to the IBM Storage Protect Snapshot node unless the /USEALWAYSONnode option is specified.

Procedure

Enter the following command to back up your standard SQL databases to the file space for the AlwaysOn node:

For example,

TDPSQLC Backup *|dbname[,dbname,...] Full /USEALWAYSONnode

You can use the wildcard character (*) to back up all databases, or specify a list of database names that are separated by commas.

For example:

TDPSQLC Backup standard_db01,standard_db02 Full /USEALWAYSONnode