SQL Server Express does not have SQL Server Agent itself to run jobs. So, if you want to run a script periodically for SQL Server Express, then you will need...

Using the backups from the production server, we have restored the databases to our development server >> have you restored the distribution database as well from "prod" into "dev"?

Is the new "dev" server using the same distributor as the "production"?

If not, then overall you seem to be following the correct path. I wonder why would there be leftover...

My problem now is that I am unable to get the initial snapshot to finish creating. We have a user in the agent that has permissions but when I look...

You will have to write custom replication stored procs, specifically the sp_MSupd_<articlename> procedure. Replication allows to create and use custom code in the article's change propagating stored procedures, namely=INS_CMD, UPD_CMD...

Win, as he has stated, he (or any user from Server B) does not have access to server A (publisher and distributor). So, they cannot query the replication metadata tables...

I don't think I have understood why would replication cause any issues with SQL logins. Did you take a backup of publisher and restore it on subscriber while creating subscription?

The...

I don't have a code readily available but you can easily compare column values using simple LIKE operator since you are majorly doing string comparison. This can be done in...

Looks like data from the .bcp file (which contains the actual data) could not be imported correctly. Try re-running your snapshot agent to create a fresh snapshot and check if...

I will suggest not to try the LOG TRUNCATE_ONLY option. Rather, find a disk with enough space and take subsriber db backup and then shrink it. After this, set up...

You haven't specified if the distributor and publisher are on the same box. Anyway, the errors are there because sp_dropdistributor is trying to clean some leftover subscriptions and publications from...

Based on what you are describing, it looks like the clustered SQL Server is publisher while standalone is the immediate updating subscriber. The immediate updating subscriber has _sync triggers to...

Have you setup regular log backups at the subscriber site? If you set log backups, then the space in the transactions log will be reused and will stop the Log...

You can easily check the article settings by querying the <publisher db name>..sysarticles table. Check the values of INS_CMD, UPD_CMD and DEL_CMD. You will have to do this in each...

The disks that you are seeing in Windows are just volumes. The disk subsystem can have single or multiple disks to present a volume to Windows. So, if there are...