December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Upgrade Options in SQL Server 2012
When you restore a SQL 2005 full-text enabled database to a SQL 2012 server, the full-text catalog will be imported into a separate filegroup in the database in its own filegroup. This is a change from SQL 2005, where the full-text catalogs were stored in the file system. A catalog rebuild should be done to take advantage of the new SQL 2012 word breakers. A SQL 2008 and SQL 2008 R2 full-text enabled database backup will be restored into the primary filegroup.
When you attach a SQL 2005 full-text-enabled database to a SQL 2008, SQL 2008 R2, or SQL 2012 server, you are prompted to attach the SQL 2005 full-text catalog when you use the wizard, and the attach database process will fail.
If you use T-SQL commands ...