AFAIK, the data in the publication HAS to be the same to start replication. You need to either do that with a snapshot, db backup/restore, or manually ensuring the data...

It's half a day if they have time. I've worked with clients and they schedule out work, so they don't necessarily have time to dedicate right away. They might have...

It should work fine the way you are doing it. I think you might need to stop both nodes to get this to work and prevent failover.

Can you note what worked? Did the line count work?

You could just import the file into one large table, single column, and then count the rows.

Glad you liked the article and was curious how things have worked for people out there. From an ex-rugby player, the idea of doing something in a Scrum appeals to...

I think that snapshots are really only useful in two places. This is theoretical and from research in talking to people.

- Quick restore after upgrades/patches. Take one before making changes,...

If you run osql from the command line, does it run? might not be in the path.

What's the issue? Do those queries not work? Or do you need them in one query?

Use and AND in the WHERE clause and include both criteria.

Run the log backups on your interval and note the sizes. This will help you figure out how big to size the log. The more often you backup the log...

Not sure what you can do there other than look for another job.

You want to perform lots of due diligence, meaning talk to more than the hiring manager. Talk to...

They should all be there. Might be some search default for the current year, but you should be able to find them all.

Thanks, fixed.

If you give more information on why you are doing this and what your requirements are, we can give you more guidance.

please post a question. the subject is not part of the question.

Your logic makes sense to me. You might some slowdowns on loads, but most likely the R10 will help your queries (reads) and the logs with the OS won't slow...