Today's Mini Post is how to change your default snapshot folder for SQL replication. A snapshot is necessary to initially initialize the database that the replicated data is being sent to. So let's look at the process, quickly and with pictures!
Pictures make everything better.
Firstly, go to the distributor instance. Right click the replication folder (Fig. 1) and choose "Distributor Properties..." (Fig. 2).
 |
| Fig. 1: Right click Replication folder. |
 |
| Fig. 2: Choose "Distributor Properties...". |
Next choose the 'Publishers' section on the left hand side and then, finally, click the '...' next to your Distribution Database name (Fig. 3).
 |
| Fig. 4: Choose "Publishers" tab. |
You will see a list of options, one of which is the "Default Snapshot Folder" option. Change that to whatever location you like (Fig. 4).
 |
| Fig. 4: Change Default Snapshot Folder location. |
And that's it. :-)
DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to politely correct or comment as you see fit. Your feedback is always welcomed. :-)
No comments:
Post a Comment