Does anyone have a TSQL script that can automatically generate the code necessary to attach ALL existing user databases using the CREATE DATABASE FOR ATTACH syntax?
example:
CREATE DATABASE [mydatabase] ON
(FILENAME=N'E:\MSSQL\Data\mydatabase.mdf'),
(FILENAME=N'D:\MSSQL.1\MSSQL\Data\mydatabase_log.ldf'),
(FILENAME=N'E:\MSSQL\Data\mydatabase_ndf.ndf')
FOR ATTACH
I have found many examples using sp_attach_db, but none with the CREATE DATABASE FOR ATTACH syntax.
Thanks,
Craig
Best Answer
This one does the job for me. You can tweak the first CTE to include or exclude specific database and it will then generate the appropriate commands.