Restoring a SQL Server database to an older version of Sql Server
In this post I would like to talk about a common issue that confuses SQL Server DBAs and developers.RecentlyI had to deploy an ASP.Net web site from the development server to the live production server.The database server on the deployment server was SQL Server 2008 R2.The hosting provider could only provide us with a SQL Server 2008 database server.Most of my colleagues thought there was no problem with that.I had a different opinion.Ι know that this is not possible. (
read more)