I passed my 70-431 exam as well and could not agree more with the information you have given. I can also recommend the exam cram book for this exam...

you cannot install sql 2000 from a 2005 disk. You will need to acquire a sql 2000 disk. You can however use the sql 2005 user cals for...

one thing you can do is check you have enough disk space to perform the backup. if you do then change the maint plan to do a transaction log...

Thanks to all for your replies. I will now implement a full backup on server A.

Adrian - thanks for the link, that explains why there is a misunderstanding on...

Hi Karl,

Thanks for your response, this was part of my original uncertainties.

I currently dont do any backups on either ServerA or ServerB, just the log shipping backups. If a...

either that or setup a backup device as a network location and use that.

If the limitations of the CPU and memory dont hold you back then the best method of backup is to do what Carlos said.

There is a third party app out...

Thanks very much dclark! works a treat.

Peter - Many thanks for your reply as well, although at the moment we are not bothered about holidays as the company it...

select *

from gentiva1407

where locationcode not in

(select locationcode from gentiva1206)

I am working on a critical path project where i know the date i should be starting a step. Knowing that this step will take 10 working days i...