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
Last activity: May 22, 2018, 09:26 AM