Hi Lynne,

We are also encountering the exact same error you have posted. Can you please tell me what you did in order to solve this problem?

We will be implementing the...

I tested it in one database and only then that it allowed to do the requirements.

If I want the user to do all of the user databases, I need to...

Thanks both for your replies.

Thank you!

I am not good in powershell scripting, so most probably I'll do it in T-SQL. The queries in your scripts will be my basis.

That's what my original plan as well to put the log in Raid 10.

Thanks.

Hi Perry,

Thank you for your detailed instruction! With experimentation on which resource to add it, I was able see now the drives in SQL ...

You made my day ... thank...

Need to check the docs then ... 🙂

We are all new actually, including the network team so we're stressed out with this!

Thanks again.

Hi Gila,

Sorry, I'm just new with this cluster thing ... could you possibly instruct me on how to do this?

Thank you.

Thanks for your reply. Yes, I've read the comparisons and each and everyone has their own opinions which makes it the more confusing.

Since we are on a tight budget, this...

Ok, that's a relief 😀

Yes I did add the group by.

Thank you for your help

Thank you all for your quick reply.

I included this in my script - ALTER INDEX ALL ON <table> REBUILD WITH (FILLFACTOR = 80).

I have also modified the script to be...

Thank you.

Do I need to do anything on the database side?

thank you so much!

Thanks for the info.

Will there be an impact somehow of the open connections to the memory usage?

Will it somehow contribute to slow reading of records?