attach multiple databases

[dgillz]

I have about 30 database I need to attach to a new server. Is there any way to do this other than one at a time?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[RobertT687]

Create a script file, connect to your new server and run it in Query Analyzer.

EXEC sp_attach_db @dbname = 'yourFirstdb',
        @filename1 = 'C:\yourfolderlocation\yourFirstdb.mdf',
        @filename2 = 'C:\yourfolderlocation\yourFirstdb.ldf'
go

EXEC sp_attach_db @dbname = 'yourSeconddb',
        @filename1 = 'C:\yourfolderlocation\yourSeconddb.mdf',
        @filename2 = 'C:\yourfolderlocation\yourSeconddb.ldf'
go
.
.
.
EXEC sp_attach_db @dbname = 'your30thdb',
        @filename1 = 'C:\yourfolderlocation\your30thdb.mdf',
        @filename2 = 'C:\yourfolderlocation\your30thdb.ldf'
go