Did you read the stuff in BOL? That would be the first step. When / if you have questions following that please post the specific question.

Additionally, Homebrew's point is...

I'm pretty confident there is no way to restore as you describe.

For removing files, see deleting data files in Books Online and you will have all that you need...

Can you get the full share path from DFS so that you can put that in place? I don't know that SQL Server actually ties into DFS references as it...

Yeah, I was thinking that since it was an install process that was failing but didn't want to get hopes up if it wasn't going to come to pass that...

I'm hoping that life wouldn't be related to SQL Server performance but... 😛

To fix this leave the job disabled. 🙂 Sorry, had to do it. Ultimately you are going to...

What are you seeing in the application log? Right click on my computer (on the server), manage, application log.... There should be some errors associated with the SQL Server process...

I haven't used this but when you generate scripts for the database, (Right click on the database > Tasks > Generate Scripts) there is an option for "Script Bindings" which...

There is no cut and dry conversion for PL-SQL to T-SQL. Oracle loves using cursors, or at least all PL-SQL developers that I have been exposed to have loved to...

This is not something I would proudly list in public but....

select 'select * into test.'+name+' from '+name from sysobjects where type = 'U'

Run this in the database and you...

What do you see if you "select * from sysfiles" when connected to the database in question?

That is a lot to discuss but not really any questions. If the question is "Can SQL Server handle this type of environment?" the answer is yes but as always,...

Jason,

This isn't an answer but just an observation based on some playing around that I have done over the last couple of days. From what I have seen the...

It will create a new snapshot agent for the publication that you are creating and it will create a new log reader agent for that database. Any other publications that...

Do you have the replicate schema changes set to true? That should make sure that they stay in sync with the publisher.

Rod - After thinking about it, I can't say that about #3. Not certain. So, test that but, you can leave the 2005 tools on there anyway just in case...