ProfessionalAmateur

less info
229 reputation
210
bio website cosmonautdreams.com
location Denver, CO
age 35
visits member for 1 year, 9 months
seen Apr 14 at 19:45

Senior Oracle JD Edwards EnterpriseOne Developer
EnterpriseOne JD Edwards CNC Administrator
https://github.com/ProfessionalAmateur


Mar
27
accepted How does the Distributor know you have seeded/initialized your Subscriber using a backup?
Mar
17
comment How does the Distributor know you have seeded/initialized your Subscriber using a backup?
This is very helpful. When you create the publication, does it immediately start sending transactions to the distributor? Or does it wait until there is a subscription?
Mar
6
asked How does the Distributor know you have seeded/initialized your Subscriber using a backup?
Feb
11
awarded  Custodian
Feb
11
reviewed Approve suggested edit on Is my Publisher database my actual source database or is it a new database?
Feb
11
comment Is my Publisher database my actual source database or is it a new database?
Thanks. My next question is if we have a massive failure and need to restore the publisher to a point in time 24 hours ago, do we need to also restore the distributor database to a point 24+ hours ago? I think the answer is yes to to ensure the distributor only has records that are also in the publisher. There is no way the distributor to know the publisher has been restored in other words.
Feb
11
accepted Is my Publisher database my actual source database or is it a new database?
Feb
11
asked Is my Publisher database my actual source database or is it a new database?
Feb
11
awarded  Yearling
Feb
10
accepted Dropped the Distibution database before disabling publishing and distribution, how to proceed?
Feb
10
comment Dropped the Distibution database before disabling publishing and distribution, how to proceed?
Thanks, I had looked at this earlier and didn't think it would work because I had not done anything with the database yet. Found the MDF and LDF files and worked like a charm.
Feb
10
asked Dropped the Distibution database before disabling publishing and distribution, how to proceed?
Jan
30
comment Could I realistically use SQL Server Express as a distributor database for transactional replication?
Database Snapshots are single point in time right? Meaning the data is only as current as the most recent snapshot? We need a solution that will provide the users near-real time data.
Jan
29
accepted Could I realistically use SQL Server Express as a distributor database for transactional replication?
Jan
29
asked Could I realistically use SQL Server Express as a distributor database for transactional replication?
Dec
2
awarded  Notable Question
Nov
13
awarded  Popular Question
Oct
2
accepted How does security context propagate between schemas within a database?
Oct
2
accepted Query with PIVOT fails with second LEFT OUTER JOIN to same table
Oct
2
asked Query with PIVOT fails with second LEFT OUTER JOIN to same table