Hi,

i'm ok with keeping the primary data file, just need to create another and transfer it across?

Hi,

Just so summarise I have currently two drives in use

c: drive - almost full and has the main data file 1.4tb

d: drive - with about 400gb free - a small...

Hi I need to do it live? Can I create new db files and move across live?

hi sorry what does this mean?

How do I do that?

I started again, deleted the subscriptions and created a new publication restored a copy of the DB to the subscriber and added into the replication with initialise with backup option.

Now...

Also getting this

Cannot insert explicit value for identity column in table 'KsPOPOrder' when IDENTITY_INSERT is set to OFF

this is the new article I added in.

Hi,

I think it has now broken replication... I haven't tried to run a new snapshot...

Date27/12/2014 21:29:42

LogJob History (BHSRVDB007-Boohoo Live2-BoohooLive2-November2-UKMANPSRVRPT01-17)

Step ID2

ServerBHSRVDB007

Job NameBHSRVDB007-Boohoo Live2-BoohooLive2-November2-UKMANPSRVRPT01-17

Step NameRun agent.

Duration31.17:44:23

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator...

OK I can run the schedule agent in the day - will it definitely just snapshot the new articles or will it attempt to finish off any snapshots that might...

It's ok it has finished now.

So adding an article now should be fast via the GUI? Am I best adding via T-SQL?

How long should running these commands take? It has been running for three minutes now? Should it be instant?

Steve.

This is the results, the bottom one is the publication in question.

So I guess it is trying to generate a complete snapshot straight away? If I disable this option then...

Hi,

Tried to run it yesterday and it ran for five minutes - causing timeouts etc... before I killed it..

Do you want me to try it again via the GUI and see what the SPID is doing? What is best way to troubleshoot this?

Steve.

I am using the GUI.