Ensure that the SQL Server is running and configured correctly, and try the operation again. ID: 2604

Shares

Yesterday morning I tried to login to SCVMM 2012R2 and I got below error. I logged it to MSSQL server over SQL Management studio to check out if availability groups are fine. After around 10 minutes of investigation I found out LOG partition on SQL server run out of free space. I had to extend LOG virtual disk drive, extend LOG partition on MSSQL server and restart SCVMM services to make it working again.

Database operation failed. Ensure that the SQL Server is running and configured correctly, and try the operation again. ID: 2604

If you are wondering how to extend virtual disk on Hyper-V 2012 R2 click on this link

0 0 votes
Article Rating

Artur Krzywdzinski

Artur is Consulting Architect at Nutanix. He has been using, designing and deploying VMware based solutions since 2005 and Microsoft since 2012. He specialize in designing and implementing private and hybrid cloud solution based on VMware and Microsoft software stacks, datacenter migrations and transformation, disaster avoidance. Artur holds VMware Certified Design Expert certification (VCDX #077).

You may also like...

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x

FOR FREE. Download Nutanix port diagrams

Join our mailing list to receive an email with instructions on how to download 19 port diagrams in MS Visio format.

NOTE: if you do not get an email within 1h, check your SPAM filters

You have Successfully Subscribed!

Pin It on Pinterest