Home » SQL Server (Page 42)
Category Archives: SQL Server
SQL Server 2008 SP3 CU8 Is Now Available !
The 8th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft Support site. Cumulative Update 8 contains all the hotfixes released since the initial release of SQL Server 2008 SP3. Those who are facing severe issues with their environment, they can plan to test CU8 in … Continue reading
Restoring a SQL Server 2005 Full-Text Catalog to SQL Server 2012
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 is to restore a full database backup to SQL Server 2012. The full database backup will include the full-text catalog is required for upgrading & importing a SQL Server 2005 full-text catalog. Backup from SQL Server 2005 When the database is restored … Continue reading
SSMS 2012 || Connect to Server (Additional Connection Parameters Page)
The Connect to SQL Server Management Studio presents a new Additional Connection Parameters Page. Use the Additional Connection Parameters page to add more connection parameters to the connection string. Steps to get Additional Connection Parameters page In Management Studio, on the Query menu, point to Connection, and then click Connect. In the Connect to dialog … Continue reading
Become Microsoft Community Contributor …..
Become Microsoft Community Contributor. I am very happy after receiving this affiliation from Microsoft last month. My MCC badge is visible now on MSDN. Profile Page : http://social.msdn.microsoft.com/profile/rohitgarg/ Reference : Rohit Garg (http://mssqlfun.com/)
SQL Server || Compress & UnComprees Backups in one Media\File
Today, We try to check of SQL server when trying to take Compress & UnCcomprees Backups in one Media\File. Query No. 1 BACKUP DATABASE DB2 TO DISK = ‘D:\DB2_FULL.BAK’ WITH COMPRESSION GO BACKUP DATABASE DB2 TO DISK = ‘D:\DB2_FULL.BAK’ WITH NOINIT Result : Run Successfully Explanation : Backup file is formatted to take compressed backup. … Continue reading