Agreed, replication is the way to go.

Transactional replication is easy to setup and get running and provides (under normal circumstances) pretty low latency copies of the data that you can...

I subscribe and heartily recommend your doing so. There are great articles, you are guaranteed to learn something new every month, and when you add on the ability to go...

No worries 🙂

If it happens again....... (here's hoping not)

Could you attach ones of the stack dumps?

use powershell

sqlps dir SQLSERVER:\SQL\<server>\<instance>\Databases\<dbname>\Tables

gives you only user tables, add -force if you want everything.

I have to say, I did get very upset when they posted a GUI for Robocopy...that just seems wrong.

/MIR is great

/LOG is the same, there is also code out there...

Open up profiler, replicate in the GUI what you want and use the information from the profile trace to get the query that you want.

I've not seen much beyond the command line options myself, that being said I use robocopy pretty much exclusively when performing file transfers across the network. The ability to have...

I would follow the process that Laerte posted. It's quick and simple to manage and does exactly what you need.

Is the layoutthe same for all the files? Are they all going into the same table? Do you have a format file?

Brutal....no toast for you then

If you're allowed flash drives you could run it right off that.

gabriel.raymer (2/5/2010)

---

I'm surprised at how many are saying Notepad++. That's my favorite too. I just wish my current situation would allow me to use it. So it's back to just...

Do you have retries enabled on your replication jobs at all? Hadn't thought of that until this second. If you pull up the SQL Agent Jobs on both the distributor...

Do you have entries in the msrepl_errors table in the distribution database for the corresponding times?