Sample Header Ad - 728x90

I need to create a SQL Server 2019 Express database from a SQL Server 2022 database

0 votes
0 answers
24 views
I have developed a database in SQL Server 2022 (and have SSMS), I need to recreate and include all data from that database on a different server which contains SQL Server 2019 Express. When in SSMS, I right click and do a restore it doesn't find my .bak file anywhere. I see the .bak file but it won't find it for me to select. I have moved the filed to multiple locations all in the root of folders I see in the selection window but the file never shows for selection I have also tried to do it via script RESTORE DATABASE [new database name] FROM DISK = 'filelocation\filename.bak' Can anything be done easily where the database gets created inclusive all of the data in each of the tables? I did a restore through SSMS and a direct query and I was expecting that it would create the database, all of the tables. I also created a new database and tried to restore the .BAK file to the newly created database it also didn't work.
Asked by mchapman13 (1 rep)
Nov 9, 2023, 09:11 PM
Last activity: Nov 9, 2023, 09:27 PM