Tag Archives: Troubleshooting

SSMS – Docker SQL Server

once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server on Linux to SSMS on you local system, in my case it is windows Pro 10. I have installed SSMS … Continue reading

Posted in Kubernetes/Docker/Container, Others, SQL Server 2017, SQL Server 2019, SQLonLinux | Tagged , , , | Leave a comment

Day 13 MySQL Performance_Schema

performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear. This database has its own storage engine –“performance_schema” Even you may have this database but it could be possible that … Continue reading

Posted in MySQL, Others, Performance Tuning, What I learned today | Tagged , , , , | Leave a comment

SQL Server 2005 – Failed Maintenance Job

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those who have legacy system and come across a issue where maintenance job failed in jobs and on maintenance plan history … Continue reading

Posted in Bug, Error Log, Limitation, Others, Troubleshooting, What I learned today | Tagged , , | Leave a comment

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading

Posted in Add/remove, Bug, Disaster Recovery, Error Log, High Avaliability | Tagged , , , , | Leave a comment

DBCC Cleaning CACHE – Memory

DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know at sql everything is on memory, memory information retrieve quickly compare to Disk. So if things are not in … Continue reading

Posted in Memory, Performance Tuning, Troubleshooting | Tagged , , , , | Leave a comment

Different ways to move Sql Server file location

Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons, we may have to move physical file of the database to another location. Following are the different ways to … Continue reading

Posted in Backup and Restore, Troubleshooting | Tagged , | Leave a comment

Denali — Day 6: indirect Checkpoint

Denali – Day 6: indirect Checkpoint I have already blog some information about checkpoint here As I have already blog about Checkpoint and how it works. Generally it works approximately every 1 minute(internal – default) . You could do this … Continue reading

Posted in Denali, Disaster Recovery, Transaction Log | Tagged , , | Leave a comment

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may get an error an en eventvwr as “Could not open error log file ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG’. Operating system error … Continue reading

Posted in Basic, Error Log, Limitation | Tagged , | Leave a comment

Restore fails with tail of log error

For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to restore earlier backup it may fail with following error Msg 3159, Level 16, State 1, Line 1 The tail of … Continue reading

Posted in Backup and Restore, Transaction Log, Troubleshooting | Tagged , | Leave a comment

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets fails with the following error Message: Executed as user: xxx\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit  … Continue reading

Posted in Bug, Limitation | Tagged , , | Leave a comment