Thank you, it's not.

I will do a restart. By the way, is there other useful queries for DBA using select .. from sys.?

Thanks

When you say the list, do you mean it is from sql server configuration manager, I can see only one sql server instance (MSSQLServer) running.

What else could I check?

Thank you

The total size may be around 100gb.

I am not aware of another instance existing on the server.

How can I find out that?

I did check in our program drive there is only one folder called MSSQL.1, no...

Thank you, it's very helpful

I checked the propery, there is no check box on read-only.Where else should I check?

Thanks

What does "retirement of SQL Server 2005 mainline support" mean?

Do they no longer support SQL Server 2005?

Thanks

The total size files are about 100 gb.

Can I use RoboCopy, never used it before, just heard it is faster?

Do I need to download something in order to run the...

Thanks, I tried both, it's false.

This is very helpful

Thank you, this is very helpful

That is one thing i checked, thanks.

I just found out there is a job of sharepoint created that tries to delete sessions every minute, after disable it, it all work...

I will play with the way you do it in power shell.

I learned powershell for windows and ad, but don't know how to work with sql server with SSMS, is...

Actually I tried to change in the database property -initial size area to a bigger size. But then I realize it is too big, now I have 50% free space,...

SP2

Thank you, that answers my question.

I did miss the second step, because I thought I already set up other steps, and also input email on the notification tab for alert.