Hello,
I need to make maintanance Microsoft SQL Server to my customer.
I do not know what to do so I would like to specify what will be processed (Index, schedule maintanance and etc.)
Maintenance should be carried out to the all existing Databases.
Also, we want to move (on the recommendation of the employee and if it is sure it will not hurt the program) the Databases files to another partition.
The work need to be do on later evening - Night GMT+2 Time.
I have all the information you need, as well as scripts you can run to immediately start optimising the customer's SQL Server environment. I will gladly assist you to set up the maintenance schedules and also assist to move the data and log files to new partitions/disks.
Hello,
I can do it for you. All maintenance works (indexes, databases state, space and health, database files moving to another partition).
Regards,
Andrey