Databases Archives - Page 4 of 5

03/10/2013 by Nitesh

Solution: The WITH MOVE clause can be used to relocate one or more files

Friends, Today working with SQL Server I was trying to restore a DB from .bak file and got a strange error while restoring using the normal procedure. I was working on SQL Server 2008 R2 and the backup was from an old version making me think the problem may be because incorrect SQL versions. The…

03/09/2013 by Nitesh

Solution: Error: 26 – Error Locating Server/Instance Specified

Friends, This is a very common problem that we face while working with SQL (be it any version of SQL) and we always spend some time to figure out the exact issue. Every time we need to look int where should we start looking for the problem. This post lists the basic issues that can…

02/06/2013 by Nitesh

How to calculate age based on 2 dates in SQL Server

Dear Friends, Often working with SQL server, we need to calculate the difference between 2 dates. We can get this done easily by using the DATEDIFF() function. Sometimes, we also need to calculate the age of a person on a specific date in SQL Server. SQL Server does not provide a direct function to do…

31/03/2013 by Nitesh

Error Codes and Explanation for MySQL Database Server

Friends, Often while working with MySQL server, we get error codes. It is a painful task to identify the exact error with the error code. This post lists all the error codes and their descriptions for MySQL server. This post does not discuss the solution for each error code, but only the description of the…

15/02/2013 by Nitesh

How to Start-Stop MySQL Server on CentOS Server

Friends, Working with Linux Servers and you often need to start/stop/restart services. Many a times we just restart the complete server to restart services. However, restarting the server for restarting services is not recommended and we can restart the services manually via commands as well. This small post is to explain how you can start/stop/restart…