Hey Guys so it sounds like solution for creating publication with the same name and deleting it works great for everyone. I just wanted to mention that I too...

I believe you have to take the following steps first

1. Drop all the tables first

2. Remove file/files from the filegroup

3. REMOVE FILEGROUP

Thanks,

Sponge

I see a lot of readers but no replies? 😛

I the issue with this statement. It had to do with my casting, too many partenthesis and...

Check to see what the gentelemen prior has indicated and let us know if it worked. If it did not work you can try to see the new TRUSTWORTHY...

Amin:

What do you mean MS does not support the move of the system databases? They have articles that instruct you on how to do it! :w00t:

Jeffrey:

I am glad you said it! I just wanted to make sure others were thinking of the same conclusion. I guess it is just how the hardware...

Steve/Jeffrey:

Thank you very much for your reply. Steve: To answer your question I am using a mainteance plan so the backup actually dumps first and then perges after...

I would be curious as to why you are trying to append a log backup as a step 2 in a job after a full backup?

Also if this was the...

Hey Guys:

Restore replace will not work in this case. I am in the exact situiaton and the resoultion to this matter comes from understanding the steps in which this...

Like always these technicalities get me every time. I will try to be careful of my wording 🙂 So what I can learn from this is the archive bit...

I am so happy I came back to view my old posts.

Thank you for this great reference!

The script I provided was re-enginered I set this up through the gui and yes I did try 1480. Still nothing. Every time I tried something I made...

I have followed the instructions and confirmed the profile the DB Mail is using is configured in sql agent and I was also able to send a test email from...

Thank you all for your timley responses.

Thanks for confirming. Any idea where I can get more details to this delima?