If I was using High Safety mode with no witness what would it do in this scenario?

How would that differ from if I used a witness?

Also how would it behave...

Ok thanks.

Ok if the database owner is a valid AD user and is deleted from AD will there be any restrictions in this scenario?

If so what would they be?

That's great thanks for your help.

Apologies or being brief. Yes it was the file I was exporting to (.txt file) which wasn't showing all of my columns.

I have exported it to a .csv file and...

Ok thanks.

I can export into a table using SELECT INTO but how can I export into a file using TSQL?

Ok thanks.

Thanks guys for your answers.

I'll have a read through that article (I can see it).

Apologies for all the questions but what if the transaction logs backups were not generating a new file each time the backup takes place.

But instead appending the existing .trn file.

This...

Was just wondering, is there no way for me to specify a specific date and time while doing the restore.

If for example I had 40 transaction log backups and wanted...

I see.

I'll give it a try, thanks.

Also to add to that, index rebuilds were not taking place up to now.

Added this in when the shrink was taken out.

There aren't any overnight processes taking place which update...

I took the shrink out 2 days ago.

Only one maintenance plan had the shrink. I have checked all of the maintenance plans since and they are all completing successfully including...

It used to until recently but not any more.