Thanks, the full process can be found on page 25 of this doc.

http://msdn.microsoft.com/en-us/library/jj191711.aspx

You answered another question I was going to ask, about reverting back with no data loss.

Again...

Thanks, Very clear.

That's the one I started with some time ago. Maybe an older version. It enabled me to get up to speed very quickly as I needed to. I was dropped...

1 It will make more sense to start with.

Do it via T-sql and set identity insert on

-- SET IDENTITY_INSERT to ON.

SET IDENTITY_INSERT products ON

GO

Yeah. Thanks I did feel that these should not be included

I found the answer.

The account was created on the Primary server. However to resolve the SID for the account on the primary must be the same as the one on...

Ah Perry didn't see that was you thought that was Gail too.

My bad!! Simple mistake although my script had a typo. The file it was looking for was MODEL.log. WHen...

Thanks Gail, was hoping you would reply. I'll have a crack with your advise later. Only my sandpit environment so BAU comes first. If I ever get the time to...

Worked.. Excellent!!! Thanks

Looks like I'm answering my own questions.

ALTER FULLTEXT INDEX ON [TableName] SET CHANGE_TRACKING Auto

They were set to Manual.

SELECT object_name(object_id) table_name, *

FROM sys.fulltext_indexes

GO

exec sp_fulltext_catalog @ftcat= 'FTNAME',@action = 'start_incremental'

Possibly down to this???

A restart didn't resolve the issue, isa rebuild be advisable in core working hours.

ANYBODY???

Yes the link seems to be the issue, this is pretty poor from MS as the overwrite is not ticked so you would expect failure.

I usually use T-SQL for restores,...

Thanks for the replies, but the dbs are not offline. I am using the GUI not T-SQL. The database nor db files should be able to be overwritten. As long...