GilaMonster (6/9/2011)

Jim Murphy (6/9/2011)

To avoid Paired Posting (concurrent posters typing answers to the same question with neither holding a thread-lock with their respective WaitStats being either PageTypeIO or CXHeadSpace),...

If you deleted it successfully via add\remove programs there is nothing further to do in the registry.

If you are planning to reinstall you may find you have to reboot the...

I've got to agree with Blandry on a lot of the sentiments aired. Technology has given end users so much but for people in support I feel we are fast...

sounds to me like the user permissions in dev and qa (and users themselves)were different to the prod users so just remapping the logins wont get back the original database...

sorry, missed last nights post!

nice article gianluca, its good to have this sort of information out there in one article.

I gotta ask though, should it really be that convoluted! MS all over. 🙂

just restore the database then add the files.

SQL uses files in a filegroup in a proportional fill basis, i.e it writes more data to the emptier files, thus attempting to...

thats ok

you HAVE to do this. The encryption is changed when the service account is changed so you need to back it up again.

Save the file wherever you want, just...

that seems to suggest its a one user license per server. I think you would be best talking to microsoft. An MSDN license may be best for you, that would...

no probs

try this

it lists the sps involved in deleting logshipping

you can use developer versions as long as the instance will not be used for any production work.

it will automatically use them

sp_help tablename