Tema: Rowguid
Ver Mensaje Individual
  #2 (permalink)  
Antiguo 16/09/2011, 15:11
Avatar de Libras
Libras
Colaborador
 
Fecha de Ingreso: agosto-2006
Ubicación: En la hermosa perla de occidente
Mensajes: 7.412
Antigüedad: 17 años, 9 meses
Puntos: 774
Respuesta: Rowguid

I used the Uninstall Publishing And Distribution Wizard, and the physical files for the distribution database persisted on my hard disk. Is this by design? When I reinstall replication, what will happen?

A. When removing distribution, SQL Server attempts to remove the physical files. However, if the distribution database is used by other clients or if there is a sharing violation when the file is being deleted, the file will not actually be removed from the hard disk. If the physical file was not removed and you try to install distribution again, a new name will be used for the distribution database.

Regards,
Libras
__________________
What does an execution plan say to t-sql query? Go f**k yourself, if you are not happy with me