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
Last activity: Nov 9, 2023, 09:27 PM