A little something about everything

internet marketing and website development made simple..

Microsoft SQL Server Management Studio 18 Error: Maintenance Plans, Back Up Database Task (is not registered for use on this computer.)

This is the error:
 
TITLE: Microsoft SQL Server Management Studio
------------------------------
The task with the name "Back Up Database Task" and the creation name "Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceBackupTask, Microsoft.SqlServer.MaintenancePlanTasks, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" is not registered for use on this computer.
Contact Information:
Back Up Database Task
------------------------------
BUTTONS:
OK
------------------------------
Install and use SSMS version 17.9 to resolve this issue.

Attach Database Microsoft SQL Server 2017 MDF & LDF

Since 2017 no longer attaches the corresponding ldf using the SQL management studio you can instead use a script to do the attach.

Here is the example:

USE [master]
GO
CREATE DATABASE [SomeDatabase] ON 
( FILENAME = N'Z:\Data\SomeDatabase.mdf' ),
( FILENAME = N'Z:\Logs\SomeDatabase.ldf' ),
 FOR ATTACH
GO