The original table has data in it and still has, that was one of the first things I checked once I had tracked down what was happening.
I've tried all...

Thanks for your help.

Not good that the GUI doesn't work especially for people like me that don't have the knowledge to do it via scripts.

When doing a Point In Time Resore should I be selecting Restore Database or Files and File Groups?

I was tought to select Restore Database but I was tought by an...

Thanks

What I can't understand is that if you put the date and time in the "To a point in time:" box why this is not setting that date and time...

From my limited knowledge looking at that script it appears that it is restoring the whole of the last transaction log and not to the time specified.

RESTORE DATABASE [MRCTest] FROM DISK = N'Z:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Pr25Company1\Pr25Company1_backup_2012_11_02_000008_4358053.bak' WITH FILE = 1, MOVE N'Pr2company1' TO N'P:\Test Data\MRCTest', MOVE N'Pr2company1_log' TO N'P:\Test Log\MRCTest', NORECOVERY,...

I did this through Studio Manager (I'm not that cleaver!)