Refresh database from SQL 2008 to SQL 2005 by using import/Export

Today I got request refresh database from Production to QA; my production server is SQL 2008 R2 and QA environment is SQL 2005. Well is it possible to downgrade database version or try to make SQL fool by detaching and attaching data and log files from higher version to lower. Database on SQL 2008 has bit different file structure and system tables and SQL 2005 does not understand the SQL 2008 structure hence cannot restore or attach/detach. Continue reading

Advertisements

Encrypt and Decrypt the columns in table – SQL Server 2005

In a company have been asked to encrypt the few critical table columns contains containing sensitive data like Credit Card No, SSN even monthly generated payslip amount. Using SQL Server 2005 or 2008 we can encrypt data using different algorithms by creating symmetric and asymmetric keys. Continue reading

SQL Databases Last Backup Data and Time with Recovery Mode

Many times DBAs find difficulty to find out when did Last full backup or Transaction log backup completed on SQL Instance and If the SQL Instance has number of database its even more difficult to find out through SQL Enterprise Manager or Management Studio.
Continue reading