Create and Import Database
We are moving databases from one server using SQL Server 2019 to 2022.
Using the script below and although it works, when coplete the new database is in recovery mode, what am I missing?
We are moving databases from one server using SQL Server 2019 to 2022.Using the script below and although it works, when coplete the new database is in recovery mode, what am I missing? CREATE DATABASE DatabaseName; RESTORE DATABASE DatabaseName FROM DISK = ‘D:BackupsDatabaseName’ WITH Replace,MOVE ‘DatabaseName’ TO ‘D:dataDatabaseName.mdf’,MOVE ‘DatabaseName_log’ TO ‘E:logLogsDatabaseName_log.ldf”; Read More