One of the most common question I get on blog is – how do I attach database without log file. I have previously blogged about it over here. I request you to read this blog post if you want a solution where you can learn how to attach database to SQL Server with the help of T-SQL.
SQL SERVER – SSMS Error During Restore: No Backupset Selected to be Restored
There are various ways of learning in my current role. Along with client engagements, reading others blog, I also learn from comment/interaction of my own blog. One of my blog readers sent below email about Backupset.
Install SQL Server 2016 Sample Database WideWorldImporters – SQL in Sixty Seconds #081
I have been a very loyal user to sample database AdventureWorks for a while, I really liked the overall database. However, as we know SQL Server releases, new features every year and along with the new features there is always need for a new Sample Database which contains all the necessary data and schema to demonstrate new features of the SQL Server. The SQL Server team has recently released a new sample database WideWorldImporters which can be used to demonstrate new features of the SQL Server.
Install SQL Server Management Studio 2016 – SQL in Sixty Seconds #080
Earlier this week, I have published a blog post where I explained how to install SQL Server 2016. One of the most asked questions was Where is SQL Server Management Studio 2016? I totally understand why this particular question is being asked often. I have decided to create a video explaining the how to install SSMS 2016.
SQL SERVER – Error: 14258 – Cannot perform this operation while SQLServerAgent is starting. Try again later
One of my clients asked assistance in fixing an interesting issue. They informed me that they are not able to run any job in SQL Agent. When they try to run the job manually, they are seeing below message related to SQLServerAgent .
SQL SERVER – Event 17058 – initerrlog: Could not Open Error Log File
If you have ever interacted with me or taken my services, you would notice that I always ask for ERRORLOG in almost all of my contact with my client. Once of my friend contacted me and when I asked for ERRORLOG, he informed that there is no ERRORLOG file and SQL is not getting started. I suggested him that we should analyze event log for further details, after interestingly, we found the following details in the event 17058 about initerrlog: Could not Open Error Log File.
SQL SERVER – Network Servers List is Empty in SQL Server Management Studio
I have in numerous places told that the first tool that I often open when the computer boots up will be SQL Server Management Studio. I get intrigued whenever someone comes up with an error relating to SSMS. There is something that gets my troubleshooting character out and I get out full swing to solve the same. Don’t you ever like such challenges? I am for sure you like similar challenges. One of my clients reported below problem with Network Servers List in SQL Server Management Studio.