ps thanks for the tips so far. Much appreciated!

Yes just that

Do i need anything around the database name? brackets or anything similar?

Just tried this but i am getting an error:

RESTORE DATABASE databaseCMS WITH RECOVERY

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '60'.

Msg 319, Level 15, State 1, Line 1

Incorrect...

The database i am testing this on isn't in use so I can safely bring the secondary one online without having to worry about not using the first one.

I just...

Thanks for the quick response, much appreciated. Looks like we are looking at getting a seperate 2005 server then!

Cheers

I managed to sort it. Thanks for the help

I managed to stop all of the SQL services. Remove the SQL apps from the control panel. I then...

Its SQL 2000 standard we are looking at. Running in 32 bit mode on x64 boxes.

How easy is it to just switch to the 64 bit version? Does...