If you are initializing from a backup, you don't need to generate those files. After that, it's the log reader agent and distribution agent that do all the work...

So for your scenario, you would need to shrink the 1 existing data file, set the size to be 7 GB, add three more data files at 7 GB...

So I was watching a youtube tutorial initializing from a backup.

https://www.youtube.com/watch?v=2KYlIK4uW5Y&t=280s

I was wondering, why didn't he create a SNAPSHOT AGENT (remarked out)  at all even if he was...

• This reply was modified 4 years, 11 months ago by  ARPRINCE.

I changed it to 1 hour and I see the files were removed. 🙂

Thanks again!

Got it - thanks!

Follow-up, when I created the publisher, the snapshot was pointing to the network path I specified [\\SERVER\SNAPSHOT].

I see it created files and folder/subfolder as well.

\\SERVER\SNAPSHOT\unc\SERVER_TESTDB_TESTDB_PUBLISHER\20200122103014\(28524 items created)

I...

Thanks for the link!

[2] Before I create a subscription, the snapshot agent status should show 100% (all articles published) - Yes?

OK I...

Attaching the pix....tnx.

Thank you both for your inputs. I will look into it.