I am trying to mount a database (SQL Server 2005) from a set of data files (an mdf file, a number of ndf files and an ldf file) from the same database on another server.
I have tried using the attach utility from the SQL Server Management Studio, specifying the mdf file in the top pane which automatically lists the ndf and ldf files in the lower.
I keep getting an error 'Could not open new database 'continuum'. CREATE DATABASE is aborted. The physical file name "h:\......\......continuum_log.ldf" may be incorrect. The log cannot be rebuilt because the database was not cleanly shut down.'
Can someone please provide step/tips on where I am going wrong or how to create a new log.