install database backup from SQL Server 2017 to local PC with SQL Express 2022
0
votes
0
answers
137
views
I am assisting a client who has recently retired from his original business and is setting up a smaller professional property management partnership.
He has been instrumental in setting up a tailored CRM system in the original business, originally in access, and then with a large table running in SQL Server 2017. It has been suggested that he continue development in his new business, using SQL Express.
I have created a backup of the 2017 database, and installed SQL Express 2022. To restore the backup to this installation, I need to start Express in single-user mode. I have not succeeded - there are a number of 'system' accounts, eg SQLWriter, Winmanagement, and I can only guess hat one of these manages to log in as the 'single user' before I can log in with my client's local account?
Can I temporarily set the various 'system' accounts in some way to enable a restore, and then put them back to their original staus?
Asked by Frank Kay
(1 rep)
Mar 8, 2023, 11:01 AM