Sample Header Ad - 728x90

Generate CREATE DATABASE FOR ATTACH for all existing user databases

2 votes
3 answers
5642 views
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
Asked by user4659
Dec 26, 2017, 04:51 PM
Last activity: May 22, 2018, 09:26 AM