Step 02: Copy databases to the new farm for upgrade to SharePoint 2013

To set a database to read-only by using SQL Server tools

1. Verify that the user account that is performing this procedure is a member of the db_owner fixed database role for the databases.

2. In SQL Server Management Studio, in Object Explorer, connect to an instance of the Database Engine, expand the server, and then expand Databases.

3. Find the database that you want to configure to be read-only, right-click the database, and then click Properties.

4. In the Database Properties dialog box, in the Select a page section, click Options.

5. In the details pane, under other options, in the State section, next to Database Read-Only, click the arrow, and then select true.

Back up the SharePoint 2010 Products databases by using SQL Server tools

You back up the databases in SQL Server Management Studio. A backup copy of the database guarantees that you have the data in a safe state if you must enable the original farm again and is required for a database-attach upgrade. Repeat the procedure for the following databases in the SharePoint 2010 Products server farm:

·         All content databases (default database name: WSS_Content_ID)

·         The following service application databases

Service application	Default database name
Business Data Connectivity	BDC_Service_DB_ID
Managed Metadata	Managed Metadata Service_ID
PerformancePoint	PerformancePoint Service Application_ID
Search Administration	Search_Service_Application_DB_ID
Secure Store	Secure_Store_Service_DB_ID
User Profile: Profile, Social, and Sync databases	User Profile Service Application_ProfileDB_ID User Profile Service Application_SocialDB_ID User Profile Service Application_SyncDB_ID

To back up a database by using SQL Server tools

1. Verify that the user account that is performing this procedure is a member of the db_owner fixed database role for the databases.

2. In Management Studio, in Object Explorer, connect to an instance of the Database Engine, expand the server, and then expand Databases.

3. Right-click the database that you want to back up, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.

4. In the Source area, in the Database box, verify the database name.

5. In the Backup type box, select Full.

6. Under Backup component, select Database.

7. In the Backup set area, in the Name box, either accept the backup set name that is suggested or type a different name for the backup set.

8. In the Destination area, specify the type of backup destination by selecting Disk or Tape, and then specify a destination. To create a different destination, click Add.

9. Click OK to start the backup process.

To restore a backup copy of a database by using SQL Server tools

1. Verify that the user account that is performing this procedure is a member of the db_owner fixed database role for the databases.

2. After you connect to the appropriate instance of the SQL Server 2008 Database Engine, in Object Explorer, expand the server name.

3. Right-click Databases, and then click Restore Database.

The Restore Database dialog box appears.

4. In the Restore Database dialog box, on the General page, type the name of the database to be restored in the to database list.

5. In the To a point in time text box, keep the default (Most recent possible).

6. To specify the source and location of the backup sets to restore, click from device, and then use the ellipsis (...) to select the backup file.

7. In the Specify Backup dialog box, in the Backup media box, be sure that File is selected.

8. In the Backup location area, click Add.

9. In the Locate Backup File dialog box, select the file that you want to restore, click OK, and then, in the Specify Backup dialog box, click OK.

10. In the Restore Database dialog box, under select the backup sets to restore grid, select the Restore check box next to the most recent full backup.

11. In the Restore Database dialog box, on the Options page, under Restore options, select the Overwrite the existing database check box.

12. Click OK to start the restore process.

To set a database to read-write by using SQL Server tools

1. In SQL Server Management Studio, in Object Explorer, connect to an instance of the Database Engine, expand the server, and then expand Databases.

2. Select the database that you want to configure to be read-write, right-click the database, and then click Properties.

3. In the Database Properties dialog box, in the Select a page section, click Options.

4. In the details pane, under other options, in the State section, next to Database Read-Only, click the arrow, and then select False.

Step 03: Upgrade service applications to SharePoint 2013