@jason, thanks for the reply, but that is information that I am already aware of and tried to state that in my original post.

@perry, I agree...

Thank You GilaMonster for the replies. I did get this figured out. There was in fact remnants of replication still on the database that was set up in...

GilaMonster, will that affect AG in anyway?

Thank you

Thanks for the reply, but looking at another customer that we have set up for replication, I see sysarticles (not sys.articles) system view and it is in the distribution database....

Let me add that this database used to be replicated. About 6 months ago we changed it to use Availability Groups.

Drilling into the Replication portion of Object...

Thank you both very much, both of these will work for me!!

So in 2012 within SSISDB there are tables that house this information. I am hoping to get this lucky within 2008 R2, I know there is not SSISDB with...

Thanks for the reply Kevin. We have a good team where I work and the Architect we work with, is spot on with everything. I am asking this...

I give up so easily and ask for help!!! I believe I have this figured out.

(ISNULL(ColumnA) ? 0 : ColumnA) + (ISNULL(ColumnB) ? 0 : ColumnB)

Thanks

Thanks Scott!!! I just figured that out and came back here to reply that I have answered my own question.

Thanks for the help!!

Good points on the cluster trying to restart the service as well as antivirus!! I will look into this sysinternals stuff. Thank You all for the replies!!!

I did not...I'm not sure I would no how to check that and I was more dumbfounded that they wouldn't copy as the service was stopped. How could you...

I'm not 100% for sure, but it was giving me, "there's another process using these files" and I could either try again, skip or cancel. It was almost as...

So our SAN/database maintenance didn't go as planned. The plan was to backup and detach all user databases; then stop the SQL Server Service. Then copy all of...

Thank You both for the replies!!! I was under the impression that if file locations, structures, and permissions didn't change I would be good to go!!!

Thanks Again!!