Moving SQL from server to workstation

Copper Contributor

I'm a general break-fix tech and normally stay as far away from SQL as I can. But here's the situation...


Client is trying to get rid of a very old server, but it's hosting the SQL database for his LOB app, an out-of-support version that the company doesn't make any more since they now are cloud based. So I'm trying to install SQL server on his workstation so he can host the database locally, the installation instructions from the software say this configuration is supported but don't have any specifics about how to do it. And contain such helpful steps as "Ensure that SQL is configured properly".


Anyway, I think I'm like 90% of the way there but the database isn't in the right state or something. I did the backup and restore thing, right-clicking on database and doing a full backup from the server. Then restoring it to SQL server on his workstation. But on the server there is a service that says 'SQL Server Agent (<database name>). And you can see that in the sql service configuration thing. But neither of those are true on the workstation. It feels like there's one last step of rebuilding the database or something (I lack the terminology here) to get it to fully restore the database.


Am I making any sense here? Assume I have no knowledge about SQL at all.

1 Reply
I assume you were able to restore the backup from the server to the workstation.
If you don't see the SQL Server Agent on your workstation because you installed Express Edition, which does not have agent.
There are certain limitations in Express Edition because it is free

Express edition
SQL Server Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. It is the best choice for independent software vendors, developers, and hobbyists building client applications. If you need more advanced database features, SQL Server Express can be seamlessly upgraded to other higher end versions of SQL Server. SQL Server Express LocalDB is a lightweight version of Express edition that has all of its programmability features, runs in user mode and has a fast, zero-configuration installation and a short list of prerequisites.