How do I proceed with restoring the Track-It! 20.xx Database to a previous backup copy on the same SQL Server where the Database already existed?

NOTE: In case you're looking to Move the Database to a different SQL Server, please refer How to move or restore a Track-It 20.xx Database to a different SQL Server
Also make sure to take a Fresh backup of the Database before proceeding, just in case, How to backup Track-It! 2020 database
In case you're unaware of where the Database is located, please refer How to check the Database name and SQL Server/Instance name for Track-It! 20.xx

There are several ways to go about this, listing down the commonly used ones.
NOTE: It is recommended that you perform the steps by making sure the IIS Admin, WWW Publishing, Track-It! Mail Processor, Track-It! Job Processor and Track-It! Infrastructure Services are Stopped on the 20xx App Server.

Method 1: Using previously taken Database backup already existing on the SQL Server

1. Log into SQL Server Management Studio (SSMS) with a SysAdmin (SA) or equivalent account.
2. From the “Object Explorer” on the top-left, expand the Server name and right-click on Databases and select “Restore Database”.
3. You will see a window similar to the following, select “Database” and from the dropdown select the 20.xx Database name:

4. Under “Destination” make sure the “Database” is the same as the “Source” Database.
5. By default, the “Restore to” option will have “The last backup taken”. You can use the “Timeline” button to change this, which will open a window as follows (It is recommended to Restore to a “Full Database Backup”:

6. After making the selections, in the “Restore Database” window select “Options” and make sure the “Tail-Log backup” checkbox is enabled as follows (If you’d like to disable it, a Database Administrator (DBA) can be consulted for more details around this):

7. Then, go back to “General” and hit “OK”.

Method 2: Using a Backup (.BAK) file you have physically present in some other location

1. Log into SQL Server Management Studio (SSMS) with a SysAdmin (SA) or equivalent account.
2. From the “Object Explorer” on the top-left, expand the Server name and right-click on Databases and select “Restore Database”.
3. You will see a window similar to the following, select “Device” and using the 3 dots next to it, browse to the Backup file:

4. Once the Backup file has been selected, in the “Restore Database” window select “Options” and make sure “Overwrite the existing database (WITH REPLACE)” option selected as follows (The “Tail-Log backup” checkbox can be Disabled OR you can leave it Enabled):

5. Then, go back to “General” and hit “OK”.

Once the Database has been restored, it is recommended to follow the below mentioned steps:

1. In SSMS, from the “Object Explorer” on the top-left, right-click on “Databases” and hit “Refresh”.
2. Now, right-click on the restored 20.xx Database and run the following queries against it using the "New Query" option:

3. Once the above queries complete execution, perform an IISRESET on the 20.xx App Server and Restart/Start the Track-It Infrastructure Service manually.