I am trying to restore a database from a backup in SSMS. I right-click on the database, select "Tasks", Restore, and Database. I then select Device and select my backup file as normal.
On the Options tab, though, I noticed that the "Trail-Log Backup" and "Server Connections" options are inaccessible, regardless of which "Recovery State" I select in the "Restore Options" - screenshot below.
What could I be missing here?
I have reviewed this page in Microsoft's documentation, but no lightbulbs just yet:
Apologies if this questions has already been asked/answered - I didn't see it on here when I searched, but could also be that I'm not using the right terms. Still very novice at this.
Thanks!