Maystyle :
Admin : New post
Guestbook
Local
media
Catergories
Recent Articles
Recent Comments
Recent Trackbacks
Calendar
Tag
Archive
Link
Search
 
해당되는 게시물 1건
  SQL 2000 / 2005 Replication 수동 삭제 방법 
작성일시 : 2008.03.26 16:26 | 분류 : SQL Server/Administration | 태그 : , , , , , , ,

Replication 의 수동 삭제는 다음의 순서에 따라 이루어 져야 한다.
구독자 > 게시자 > 배포자

[게시자 삭제 방법]

스냅샷 게시자 삭제 (sp_droppublication)
You can use the sp_droppublication system stored procedure to drop a publication and the articles that are associated with the publication. You must run the stored procedure at Publisher on the publication database.
- 예
USE <Publication database name>
GO
EXEC sp_droppublication @publication = N'<Publication name>'
USE master
GO
exec sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'

트렌젝션 로그 게시자 삭제 (sp_dropmergepublication)
You can use the sp_dropmergepublication system stored procedure to drop a merge publication and the Snapshot Agent that is associated with the merge publication. The articles that are associated with the publication are also dropped. You must run the stored procedure at Publisher on the publication database.
- 예
USE <Publication database name>
GO
EXEC sp_droppublication @publication = N'<Publication name>'
USE master
GO
EXEC sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'

머지 게시자 삭제 (sp_replicationdboption)
You can use the sp_replicationdboption system stored procedure to set a replication database option for the current database. You must run the stored procedure at the Publisher server.
- 예
USE <Publication database name>
GO
EXEC sp_dropmergepublication @publication = N'<Publication name>'
USE master
GO
EXEC sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'merge publish', @value = N'false'

구독자 / 배포자 삭제 는 다음 문서를 참고한다.
http://support.microsoft.com/kb/324401

Name   Password   Home   Secret   Submit