Home » 2012

Yearly Archives: 2012

Happy New Year 2013

Merry Christmas to all of you…

Merry Christmas to all of you….

SQL Server 2012 SP1 CU1 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site.

SQL Server 2012 SP1 CU1 contains fixes released in SQL Server 2012 RTM CU 3 & 4. For those who are upgrading to Service Pack 1 from SQL Server 2012 RTM CU3 or CU4 should consider applying SQL Server 2012 SP1 CU1 to ensure fixes resident on the system are available post upgrade to Service Pack 1.

For CU1 of SQL Server 2012 SP1

Obtain SQL Server 2012 SP1

· Microsoft® SQL Server® 2012 SP1

· Microsoft® SQL Server® 2012 SP1 Express

· Microsoft® SQL Server® 2012 SP1 Feature Pack

· http://mssqlfun.com/2012/11/08/sql-server-2012-sp1-is-now-available/

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 test environment & then move to Production after satisfactory results.

To other, I suggest to wait for SP4 final release to deploy on your production environment, to have consolidate build.

For CU8 of SQL Server 2008 SP3

Previous Cumulative Update KB Articles:

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 on SQL Server 2012, a new database file will be created for the full-text catalog. The default name of this file is ftrow_catalog-name.ndf. For example, if you catalog-name is userdetails, the default name of the SQL Server 2012 database file would be ftrow_Userdetails.ndf. But if the default name is already being used in the target directory, the new database file would be named ftrow_Userdetails-name{GUID}.ndf, where GUID is the Globally Unique Identifier of the new file.

After the catalogs have been upgraded, the sys.database_files and sys.master_files are updated to remove the catalog entries and the path column in sys.fulltext_catalogs is set to NULL.

File details after restore on SQL 2012

Reference : Rohit Garg (http://mssqlfun.com/)

%d bloggers like this: