unfortunately not, data needs to be read/write.

I was thinking at the moment along these lines,

Backup Live

Set testDB to single user

take test DB offline

take test db online

set test...

Thanks for the reply, Maybe i should provide a little extra info,

The LIVE db is for a Financial system and accessable to all as is the TEST. The test...

Thanks for the reply, Any suggestion to ensure that the DB i'm restoring to i will have exclusive access to, there will be occasions when users have not logged off...