STAR!!! I got it. Cheers for that mate.

Only one installation. I've tried both methods.

hehe cheers for that.

aaaarrrggghhh!!! Problem is, this doesn't find anything, but tells me its in use when I try and...

Like this you mean?

Select * from master.dbo.SysFiles where name = 'Main1st_Bruce1_Data.MDF' and FileName = 'H:\samf\bruce\Main1st_Bruce1_Data.MDF'

I'll take a look at this and give it a go. Many thanks

Will the below be suffice?

DELETE FROM SysObjects WHERE Name = 'MSpub_identity_range'

Thanks Yelena

There is 25GB free on the hard drive. The bak file is only 37MB in size. Nothing of any signifance in the Event Viewer. Only the actual...

I'm just using the restore database from the right click menu against a database in Enterprise Manager. Reading from media, ticing force restore and then changing the physical file...

Already done that. All seems OK now. Many thanks for all your advice.

Thanks for that. I've got this working again now. There were two records that contained a reference to a foreign key. These foreign key records had somehow...

Thanks for that. I'll try these