hopefully you have started the Snapshot job for that publication.

Drives can fail very badly at the least expected time. At that point, you have lost your database. I would not compromise the safety of the Db for a tiny...

If you are talking about rebuilding a Clustered Index, then I think yes. I am not sure about that. I am not sure what you meant by updating a clustered...

You will have to check the server Specs to see how many channels it has. Usually there is one Internal IO card that will have two channels. This will be...

How many IO channels do you have in the server that you have? Do you have any additional IO card? If not, you will probably use one for your OS...

Somebody please put the brakes on the THREAD. It keeps moving from one random topic to another. It does not even care who gets run over with these topic changes.

With your hands tied behind your back, you do not have much option than live with what you have I guess.

Regarding SQL 2012, I would always wait for the first...

A view can select only from Tables or other views.

A better solution would be to create a stored proc instead of a view that can handle the parameters you...

Here is something that you have to keep in mind. If on the first attempt to clean up the old directory fails due to some reason like file being locked...

Where are they trying to alter the SP's? In the Live DB or the Snapshot DB?

I have heard lots of issues like this. 90% of the time, it is the permission issue. The agent job that runs it does not have rights to delete files...

You can specify in your Transactional replication to ignore delete command.

Another way is to modify the Stored proc (Replication SP in your MAIN where you are replicating to) to...

Brandie Tarvin (1/25/2012)

---

I wish I could attend all the international SQL Saturdays. That would be so much fun.

I have been thinking about testing remote presentation at some U.S. Saturday's though,...

Not enough info to help you here.

What type of replication do you have?

What was the sync method you used?

Did you stop the log reader agent turned of for a long...

Thanks Jason, Thanks Wayne...