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
- MSSQL_ENG018456 error - Help me please
- Wierd results with != operator
- rendering to multiple Excel Workbooks from one Report in Reporting Services 2005
- 2 minutes after one datetime vs. another datetime
- Executing MDX queries from inside SQL Server Stored Procedures (SQL Server 2005)
- Return the data from a table ordered by its hierarchy
- SSIS & SharePoint Lists
- installing sql server mobile in an hp ipaq rx1955
- no help dialog in vs ssis
- running number
SQL Server
- Different Aggregation Function for Single Measure
- Execute package via a web application failing
- Win CE 4.2 and Smart Dev Application question
- Merge join problem
- Using an External Dataset with Reporting Services
- Linked server table name with period issue
- Format file (regsrvr)
- Create schemas programatically.
- FTP Task issue
- Why is UDF class declared partial?
Restoring a databse user
sunnydhiman
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.