SCCM DB Move - Part 2 : Restoring DB on another Server

Restoring SCCM DB on Server 2:-

Restoring a SQL Server 2008 R2 database involves several steps, including backing up the database, restoring the backup to the target server, and ensuring that the necessary settings are configured correctly. Here's a general outline of the process:

1. Create a Backup: Ensure you have a valid backup of the database you want to restore. The backup could be in the form of a full database backup (.bak) or a transaction log backup (.trn).

2. Copy the Backup File: If the backup file is located on a different server or location, copy it to the server where you want to restore the database.

3. Connect to SQL Server Management Studio (SSMS): Log in to SSMS with appropriate administrative credentials.

4. Restore the Database:

   - In SSMS, right-click on "Databases" and choose "Restore Database."

   - In the "Restore Database" window, select "From Device" and browse to the location of your backup file.

   - Choose the backup to restore from the backup media and provide a destination database name.

   - Ensure the "Restore" options are appropriately set. Common options include:

     - Restore Options: You can specify whether to overwrite the existing database or create a new one, as well as how to handle existing file locations.

     - Recovery State: Choose whether to restore the database in a "RESTORE WITH RECOVERY" or "RESTORE WITH NORECOVERY" state. The former allows the database to be operational after restoration; the latter allows further log backups to be applied.

     - Relocate Files: If the original file paths are different on the target server, you may need to specify new file locations.

     - Restore the Transaction Logs: If you have a full database backup along with one or more transaction log backups, you'll need to restore the transaction logs in sequence after the full backup to bring the database up to the most recent point in time.

5. Start the Restore: Once you've set all the necessary options, click "OK" to start the restore process.

6. Verify the Restore: After the restore process completes, check the database in SSMS to ensure it is accessible and all the data is intact.

Remember, before performing any database restoration, it is essential to back up your existing databases and exercise caution to avoid data loss.

Server2:-

Open the SQL console on server 2:-

 

 

 

Provide the location of the file here :-