One would be to have permission to the shares (Your source file and target file). The user that runs the service should also be a domain account (Not an admin)...

Gail is onto the Corruption thread. Now I can stop giving stupid advice....:hehe:

Here are couple of things to keep in mind.

1. RAID configuration

2. IO controllers

3. RAM (64 bit- No limit for RAM)

4. Use different drives for the Data files, Log files ,...

Maybe xp_cmdShell is disabled? Default is disabled. Also the service account might not have enough permissions to do this. I assume you are a local admin / domain admin and...

george sibbald (2/23/2010)

---

cheers Roy for joining in. More...

I hope the OP investigates it further before he tries any recovery.

SAT SQL. Please check the error log of SQL Server first and see what is happening. Maybe it could be resolved. Also do what George Sibbald said. It is very...

Rob, Here is something you might want to think about. let us say something happened to your Distributor. Your replication is dead in the water. How are you going to...

Before you truncate anything, first check what recovery model your Distribution DB is

I got this query from the Blog of Jimmy May. This will show all your waitstats. Also look at this Link.

http://blogs.msdn.com/jimmymay/archive/2008/10/30/drum-roll-please-the-debut-of-the-sql-dmv-all-stars-dream-team.aspx

There is a Hyperlink on "DMV All-Stars Dream Team" Download...

I thought that during the weekend the MVP talk would have been done and finished with. Seems like it is still going strong... 🙂 MVP season is in the air..:-)

Stop the log reader agent and then you can shutdown in any order. It does not matter. Once your SAN is back online and you start up your SQL Server...

You could use transactional replication. It should not be a problem if you do not have high latency between your hosting services and your office.

Thanks for the update. I am sure someone else could gain from the knowledge you had just given.

Tim Januario-145496 (2/19/2010)

---

Yes!!! I am post 11,869 on a single thread. I went all the way to the beginning and read every single one. BTW - very funny...