GCMA database needed to moved to another drive. The current file and drive location is E:\MSSQL\Data\GCMA_1.mdf .
GCMA was Detached and moved from the E:\ drive to a like folder on the G:\ drive.
Toad for SQL Server 5.5 was instructed to look on the G:\ where it found G:\MSSQL\Data\GCMA_1.mdf
In review of the attach syntax, it was noticed that Toad for SQL Server 5.5 incorrectly assumed the log file was also going to be at location G:\MSSQL\Data\GCMA_2.ldf
However, the LDF was not moved from F:\MSSQL\Data\GCMA_2.ldf, thus building an attach script syntax that would have failed, because the LDF found was not on the G:\ drive.
I checked with SQL Server Management Studio and found that it knew where the LDF was correctly located and built the attach script syntax correctly.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center