SQL 2008 | Varinder Sandhu

Restore SQL 2008 full database backup to SQL Server 2005

Varinder Sandhu SQL, SQL-Advanced, SQL-Backup & Restore, SQL-General, Varinder Sandhu

My friend wants to restore the SQL 2008 full backup to SQL Server 2005. He faced an issue while restore the SQL 2008 full backup to SQL Server 2005. He has a question from me as: Can we restore the SQL 2008 full database backup to SQL Server 2005? Answer: No, we can’t restore a backup from a higher version of SQL Server on a lower version of SQL Server. Alternative: If you are not using any features specific to

» Read more

Database Backup, SQL, SQL 2008

List of datatypes in SQL Server

Varinder Sandhu SQL, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

We are using very few data type in SQL Server like INT, varchar,datetime etc But there are currently 37 datatype supported by SQL Server 2008 See the below scripts exec sp_datatype_info select * from sys.types exec sp_datatype_info_90 exec sp_datatype_info_100

» Read more

List of datatypes, SQL, SQL 2008, SQL Server