Viewing 7 posts - 16 through 22 (of 22 total)
Cool. I am not home right now, but can help more if needed. Comments and questions above are all good.
You can drive this from a table, excel spreadsheet,...
July 28, 2017 at 10:44 pm
Am curious as to whether this a one time event or not. Also wonder how you are going to decide which 200 databases to run the scripts against....
July 28, 2017 at 9:58 pm
We need more information. Could be a lot of things like data being loaded into cache...is it blocking that just seems to be happening at the same time...a crazy long...
July 28, 2017 at 7:03 pm
Or maybe you could have a script that stops the services then starts the job instead of having the job stop the services.
July 28, 2017 at 6:58 pm
I am in the middle of something similar with an app I am building. Your maintenance on SQL Server will not be handled the same on MySQL...SSC guru mentions this....
July 28, 2017 at 6:56 pm
Did you get what you needed from the answers? Good question about the databases being on the same machine or instance too. If on a different machine you could even...
July 28, 2017 at 6:54 pm
Want to share a little history. I've been a SQL Server DBA since about 2003. Even wrote an article for SQL Server Central back in the day. Anyway, quite a...
July 28, 2017 at 6:02 pm
Viewing 7 posts - 16 through 22 (of 22 total)