Can not attach database to SQL Server Express 15.0

SuperCoder 236 Reputation points
2025-05-30T15:44:06.1033333+00:00

SQLIssue1.pdfSQLIssue2.pdf

Want to attached FosterTrak database to SQL server but it does not appear on the add list as shown in images. Have done this dozens of times. How do I fix this?

SQL Server Database Engine
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2025-05-30T19:38:37.6833333+00:00
    CREATE DATABASE FosterTrak
    ON (NAME = 'FosterTrak', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS01\MSSQL\Data\FosterTrak.mdf')
    LOG ON (NAME = 'FosterTrak_Log', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS01\MSSQL\Data\FosterTrak.ldf')
    FOR ATTACH
    

    Note that the two pictures you have share are looking in different folders.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.