You have made my day. I have read endless articles and consulted numerous eggheads without any results. It works now

Thanks

🙂

I have used this:

Use Master

Go

RESTORE DATABASE [rotary1] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\rotary.bak'

WITH NORECOVERY,

MOVE N'Rotary_Primary' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\rotary1_1.mdf',

MOVE N'Rotary_Data' TO...