I am having site collection with its own content database in development and production environment. Now i am facing some issues in production side. I tried to take site backup and restore it in development environment but i can't do that because of sharepoint version problem. Now i am trying to get backup of production content database and restore that database in development SQL server. Is it possible to point my development instance to point production content database instead of its own database? How can i achieve this??
Your choices are to either make sure that the versions of SharePoint and SQL Server on your dev machine precisely match what is in production, right down the the Cumulative Update and/or hotfixes - or to use a third party tool to export the entire site into a neutral format and then reimport it into dev. The problem with the latter is that it is entirely possible that doing so will fix whatever it is you are trying to debug.
It is technically possible to have newer versions of SharePoint and SQL Server on Dev but doing so also introduces the possibility that one of the newer patches also fixes the issue you are trying to debug.