Hi
My Bridge Club has purchased a new windows 11 computer (it will not allow me to copy over a system image). The bridge scoring program requires the SQL system to be on the new computer. Once this is copied to the new computer, I will have no further interest in SQL. I can read plain English but can find no step by step guidance on how to do this. Surely others have also needed to do this. Any help here or where to look? So far, I have installed Microsoft SQL server 2022 and Microsoft SQL server tools 21.
Take a back-up from the bridge system on the old system and restore it to the new SQL Server. Set up the backup jobs and check if there are other jobs running on the old system that need to be copied.
1 Like
Hi NoellaG
Yes, backup(s) of databases have been taken from the source windows 10 laptop and copied to the new Windows 11 computer. SQL Server Management studio opened and a freshly installed SQLEPRESS connected. Right click on Databases and select Restore Database.
Of course, I have done this wrong as there is no option to source the backups.
I can try this and try that to do what should have been a simple task and have with no success. So, how do I get those backups from the source laptop functional on a new laptop?
Create a new database with the same name, and than right click the database -> tasks -> restore use the backup file as the restore source. Beware, if you are using SQL express, best to put the reovery model to simple. On express you can't create jobs, so best to create a backup plan in Powershell.
Success!! Google finally gave me clear abc instruction!
Restore a database to a new location (SQL Server) - SQL Server | Microsoft Learn