I am sure this will be a learning for me too about SQL Server Management Studio. Below query would say express editionĭo you know any other reason? Please share via comments. Logged in account not having sysadmin permissions.To summarize, there could be 2 reasons which I could find. Since there is no SQL Agent with SQL Server, there is no point of scheduling and hence no maintenance plan folder. This was an EXPRESS edition of SQL Server. 5 (X64)Įxpress Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 (Build 9600: ) (Hypervisor) Here is the output he shared with me for “select SQL Server 2016 (RTM) –. When I got his reply, things were crystal clear. Yay!! I don’t see SSMS but this is not exactly matching with reader’s SSMS. But, there is what I saw when I logged it with that account, which was not a Sysadmin. While I was waiting, I tried to think the cause and created a public account in my lab’s SQL Server. Since it was SQL Server 2016, I thought that there is something new. In my reply to his email I asked for complete snapshot of object explorer and output of select output. I have tried to repair of management studio and SQL Serve engine, but none of them helped.ĭo you have any pointers to fix this weird issue? As you must have imagined that I am not a SQL DBA but a DBA by project demand, so please be generous. I was surprised to see that I am not having folder called Maintenance Plan. I read on internet and found that I can created maintenance plan to take backup on scheduled basis. Since it’s a financial data, I wanted to make sure that we have backups taken regularly. I have installed SQL Server 2016 for my 3 rd party software. One of my readers sent an email as shown below about Maintenance Plan Folder Missing Under Management in SQL Server Management Studio: I take this an opportunity to connect with various people and look for active solutions one has achieved from their experience. These are a great source of experimentation and a lot of searching to get to the appropriate error resolution. The best part of learning is by the error messages that each one of you send me over the years.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |