I'm new to working in SQL, so forgive my lack of terminology.
I have this database that stores sales conselors clients. One of the sales counselors is missing 1200 of his clients after synchronizing. (down to 694) When I look in the replicated database, it shows the full 1894 clients.
Is there a way to restore his database from the replicated
HELP
Restoring a databse user
Hot Topic
- Unhandled Exception in Management Studio
- Internal error: file 'dmattributeset.cpp', line 2004
- Process Analysis Services task missing Update Dimension
- Using DMX to rename clusters
- Help Designing an App. to be Run from a Job
- Heeeeellllllllppppppppp!!!! Replication Latency in Dist Agents
- How to allow remote connections to SQL Server 2005 Express database
- how to give access my report to particular users
- Transactions in Data Flow
- Read only or hidden report parameters in Reporting Services
SQL Server
- Run SSIS Package problem when using SQL Agent
- @@servername returns NULL value
- Problem to view OLAP data on web
- Role - Read access - Analysis Services 2005
- SQL 2005, replicating Encrypted Data?
- Can update in SQL 2000 but not express beta 2
- Incremental Update
- Reporting Services Count
- A Problems after the install of the Hotfix
- SqlCeConnection guidelines - keep it open?
Restoring a databse user
DanTi
Is this Merge replication Are there any filters or constraint violations involved
Were the rows deleted on the other site
However If your current aim is to get back all the rows and have 1894 rows at both the sites, you will need to dummy update (update col1=col1) all the 1894 rows (or atleast the missing 1200) rows and synchronize again. That way the sync should pick those changes when it runs the next time.