Transitioning standard SQL Server databases to the AlwaysOn node

You can back up standard SQL Server 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

The AlwaysOn node name is required when you configure Data Protection for SQL Server 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 Data Protection for SQL Server node unless the /USEALWAYSONnode option is specified.

Procedure

  1. To back up your standard SQL Server databases to the file space for the AlwaysOn node, specify the /USEALWAYSONnode parameter with the backup command as follows.
    For example, issue the following command 
    TDPSQLC Backup *|dbname[,dbname,...] Full /USEALWAYSONnode
  2. To back up all databases, specify the wildcard character (*) or specify a list of database names that are separated by commas.
    For example:
    TDPSQLC Backup standard_db01,standard_db02 Full /USEALWAYSONnode
  3. To regularly back up standard SQL Server databases to the file space for the AlwaysOn node, specify the /USEALWAYSONnode parameter with the set command.