Surface-enhanced Raman spectroscopy (SERS) is a powerful vibrational spectroscopy technique with distinguished features of non-destructivity, ultra-sensitivity, rapidity, and fingerprint characteristics for analysis and sensors. The SERS signals are mainly dependent on the engineering of high-quality substrates. Recently, solid SERS substrates with diverse forms have been attracting increasing attention due to their promising features, including dense hot spot, high stability, controllable morphology, and convenient portability. Here, we comprehensively review the recent advances made in the field of solid SERS substrates, including their common fabrication methods, basic categories, main features, and representative applications, respectively. Firstly, the main categories of solid SERS substrates, mainly including membrane substrate, self-assembled substrate, chip substrate, magnetic solid substrate, and other solid substrate, are introduced in detail, as well as corresponding construction strategies and main features. Secondly, the typical applications of solid SERS substrates in bio-analysis, food safety analysis, environment analysis, and other analyses are briefly reviewed. Finally, the challenges and perspectives of solid SERS substrates, including analytical performance improvement and largescale production level enhancement, are proposed.