Do you take log backups during the day and at what frequency are the log backups taken? How much data can you afford to lose in the event of corruption...

Have a look at the reports or run sp_spaceused on each node and instance you want the information for.

Cheers

You can use the in-built reports in Management Studio. Right click on the tempdb database in Management Studio -->Reports-->Standard Reports -->Disk Usage

If you Google this or look in Books Online you will find all the steps to restore a database.

Thanks

The differential will just include any changes since the last successful full backup so as the full backup was cancelled you should expect the diff backup to be larger than...

I notice you've raised another topic regarding memory pressure. Is this happening on the same server?

Have a look at QA too, they look to have some locations close to Portsmouth. I've done a few courses with them and they are good. I found their online...

I agree, I did my online course with Gethyn and he was excellent. The setup is very good for the online courses. The course material plus headset is mailed out...

For online courses I've found Learning Tree to be excellent. Courses are designed to help you prepare for the exam so do not include the cost of the exam itself.

Can you not just create a linked server between the two and script out the INSERT INTO......SELECT * FROM??

Thanks

I think it is the best 3rd party product out there. It's great for testing your backups are good and can be restored.

Cheers

I'd probably set it at 24gb and leave 8gb for the OS. 32gb is not much for a production server so keep an eye out for any memory alerts as...

You learn something new everyday. This is not a term I'd come across before.

Sorry, there still isn't much information here. Are you trying to find out how to improve security for your databases and what do you mean by hardening resources? What resources?