Thanks heaps Kudikai the vmware fix worked for me

I have a similar problem with a brand new server 2012 and sql server 2012 installation using the standard sql version.

I can only restore/attach a db to my D and...

I've been trying to find out about NO_TRUNCATE for a while as there is something I fundementally don't understand about it.

If you are backing up the active portion of the...

It doesn't make sense to be able to 'skip' the db backup and still restore everything. The only way that makes sense is if the log backup (after the db...

...just thought of a way, drop all replication subscriptions and publications, restore the Sydney db, then restore the UK one as as it would have been as at or before...

Thanks Sergiy

Problem is he wants to run it from a stored proc, so it has to be all t-sql.

I have found some code to script everything but it's difficult to...

Ditto, worked like a dream.

Thanks a lot Greg

I realise what you've suggested is repeated - probably in great detail - in BOL, but your version in plain English is finally sticking in my virginal DBA...

Thanks Greg

That makes sense, now the follow up question.

I'm backing up user databases, although most of them are DEV, have a full BK running weekly, differentials running daily OBH, and log...