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.
