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.
