i was having this issue while implementing replication from SQL server 2008 to sql server 2005 . the DB on sql server 2008 was restored from another sql server 2005 server.
While Synchornizing the data with publisher data i have this error .
snapsthost is corrupted or not fully generated
so I just changed the owner of both databses on publisher server and also on subscriber server using this code
USE databsename
GO
sp_changedbowner sa -- to change DB Owner
ALTER AUTHORIZATION ON DATABASE::databsename TO sa --change the authorization schema.
No comments:
Post a Comment