Attaching database

[aspeed]

Is there any way in SQL2000 to attach a database using only the .mdf file with no log files. It gives me an error
saying that it cant find the log file. It has been deleted.

 

[stef315]

Maybe you can first create the database new. Then copy that ldf file to use during the attach? I've never tried this, just an idea.

 

[cmmrfrds]

Try the single file attach. Basic syntax.

-- attach database
sp_attach_single_file_db 'MAS_CHM',
'c:\Program Files\Microsoft SQL Server\MSSQL\Data\MAS_CHM.mdf'

Usually, before you can do an attach the file must have been detached from the other server before being copied.