Error cannot open metabase because of error related to h2 database and migrating Metabase DB

C:\DSA\Metabase>java -DMB_JETTY_PORT=1111 -jar metabase.jar

2024-03-27 13:09:25,993 INFO metabase.util :: Maximum memory available to JVM: 1.9 GB
2024-03-27 13:09:27,458 WARN db.env :: WARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see Redirecting…
2024-03-27 13:09:27,638 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
For more information, see Redirecting…
..instrumented #'metabase.util.malli/with-api-error-message
..instrumented #'metabase.util.honey-sql-2/identifier
..instrumented #'metabase.util.honey-sql-2/normalize-type-info
..instrumented #'metabase.util.honey-sql-2/with-database-type-info
..instrumented #'metabase.util.honey-sql-2/cast
..instrumented #'metabase.util.honey-sql-2/quoted-cast
..instrumented #'metabase.util.honey-sql-2/maybe-cast
..instrumented #'metabase.models.permissions/classify-path
..instrumented #'metabase.models.permissions/classify-data-path
..instrumented #'metabase.models.permissions/generate-graph
..instrumented #'metabase.models.permissions/->v2-path
..instrumented #'metabase.models.permissions/update-db-data-access-permissions!
..instrumented #'metabase.models.permissions/update-group-permissions!
..instrumented #'metabase.models.permissions/update-data-perms-graph!
..instrumented #'metabase.models.parameter-card/upsert-or-delete-from-parameters!
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.math, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.test, being replaced by: #'kixi.stats.math/abs
WARNING: abs already refers to: #'clojure.core/abs in namespace: kixi.stats.distribution, being replaced by: #'kixi.stats.math/abs
..instrumented #'metabase.query-processor.middleware.permissions/check-query-permissions*
..instrumented #'metabase.driver.sql-jdbc.sync.describe-database/simple-select-probe-query
2024-03-27 13:09:34,660 INFO driver.impl :: Registered abstract driver :sql
2024-03-27 13:09:34,664 INFO metabase.util :: ⮦ Load driver :sql took 59.0 ms
2024-03-27 13:09:34,666 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
2024-03-27 13:09:34,669 INFO metabase.util :: Load driver :sql-jdbc took 66.6 ms
2024-03-27 13:09:34,669 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
..instrumented #'metabase.driver.h2/classify-query
2024-03-27 13:09:34,702 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2024-03-27 13:09:34,725 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
..instrumented #'metabase.models.params.custom-values/values-from-card
..instrumented #'metabase.api.card/param-values
..instrumented #'metabase.api.dashboard/chain-filter
2024-03-27 13:09:35,864 INFO metabase.core ::
Metabase v0.46.1 (12a6e1d release-x.46.x)

Copyright © 2024 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2024-03-27 13:09:35,872 INFO metabase.core :: Starting Metabase in STANDALONE mode
2024-03-27 13:09:35,911 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 1111}

2024-03-27 13:09:35,967 INFO metabase.core :: Starting Metabase version v0.46.1 (12a6e1d release-x.46.x) ...
2024-03-27 13:09:35,989 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "Java(TM) SE Runtime Environment",
"java.runtime.version" "21.0.1+12-LTS-29",
"java.vendor" "Oracle Corporation",
"java.vendor.url" "https://java.oracle.com/",
"java.version" "21.0.1",
"java.vm.name" "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version" "21.0.1+12-LTS-29",
"os.name" "Windows 10",
"os.version" "10.0",
"user.language" "en",
"user.timezone" "Asia/Saigon"}

2024-03-27 13:09:36,003 INFO metabase.plugins :: Loading plugins in C:\DSA\Metabase\plugins...
2024-03-27 13:09:36,392 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :athena...
2024-03-27 13:09:36,393 INFO driver.impl :: Registered driver :athena (parents: [:sql-jdbc])
2024-03-27 13:09:36,415 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2024-03-27 13:09:36,416 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql])
2024-03-27 13:09:36,427 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2024-03-27 13:09:36,429 INFO driver.impl :: Registered driver :druid
2024-03-27 13:09:36,436 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2024-03-27 13:09:36,442 INFO driver.impl :: Registered driver :googleanalytics
2024-03-27 13:09:36,462 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2024-03-27 13:09:36,465 INFO driver.impl :: Registered driver :mongo
2024-03-27 13:09:36,485 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2024-03-27 13:09:36,487 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2024-03-27 13:09:36,488 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2024-03-27 13:09:36,511 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2024-03-27 13:09:36,513 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:sql-jdbc])
2024-03-27 13:09:36,521 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2024-03-27 13:09:36,523 INFO driver.impl :: Registered driver :redshift (parents: [:postgres])
2024-03-27 13:09:36,562 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2024-03-27 13:09:36,565 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc])
2024-03-27 13:09:36,579 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2024-03-27 13:09:36,583 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc])
2024-03-27 13:09:36,591 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2024-03-27 13:09:36,593 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like])
2024-03-27 13:09:36,606 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2024-03-27 13:09:36,607 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc])
2024-03-27 13:09:36,611 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2024-03-27 13:09:36,613 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc])
2024-03-27 13:09:36,625 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.

2024-03-27 13:09:36,627 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2024-03-27 13:09:36,629 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]
2024-03-27 13:09:36,631 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2024-03-27 13:09:36,638 INFO db.setup :: Verifying h2 Database Connection ...

I made a copy and it worked but reinstalled from scratch and lost all my data. Is there any way to run the old one again without losing the error? I don't want to have to start over from scratch

I don’t see any error in those logs. We mention in many places that you NEED to use a database like Postgres or MySQL if you don’t want to lose all your stuff as H2 is only fine for testing

Before that, I used SQL server as a database and it worked normally. But a few days ago, metabase was turned off. I tried to turn it back on, but it said the above message and automatically turned off cmd running with the command java -jar metabase.jar.

SQL server is a database we connect to as a DW, but NOT as an application database, we only support postgres or mysql as application databases Configuring the Metabase application database