Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ivanho
Starting Member
4 Posts |
 Posted - 2010-03-08 : 02:09:14
|
| Hi,There's this Replication in MS SQL.We use it to replicate the one table, less than 10 fields to other servers for example.But everytime it will snapshot the replication and make the HDD space (publisher machine) resouces hungry. We set to replicate every 15 minutes. And the snapshot takes up 5G HDD space within 10 days.If we do a cleansing on the snapshot on publisher, will that affected the replication result in subscriber ? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-08 : 11:44:26
|
| If you're using Transactional Replication, then disable the snapshot job.You only need to snapshot when you're modifying the publication (or recovering from synchronization errors)Also, again if this is a transactional publication, you can delete the contents of the snapshot directory safely. |
 |
|
|
ivanho
Starting Member
4 Posts |
Posted - 2010-03-15 : 06:22:18
|
| Hi Russell,We are not using transactional, we are using snapshot replication. Can the content be deleted ? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-15 : 13:48:23
|
| after it has been distributed, yes |
|
|
|
|
|
|
Question on SQL replication