无法在localdb v\11.0中创建索引目录

本文介绍了无法在localdb v\11.0中创建索引目录的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

SQL语句：

CREATE TABLE [dbo].[indexTable] (
    [mapId]   VARCHAR (50)  NOT NULL,
    [keyword] VARCHAR (900) NULL,
    PRIMARY KEY CLUSTERED ([mapId] ASC)
);

Go
CREATE FULLTEXT CATALOG FTSearch

我获得

我使用与visual studio 2012一起安装的 localdb \v11.0 。

I am using localdb\v11.0 that is installed along with visual studio 2012.

推荐答案

localdb\v11.0 不支持全文索引。我安装了 MS SQL Server 2012 express与高级服务，它的工作方式像一个魅力。我不得不重新创建一个全新的数据库，虽然它不是真的很麻烦我，因为我只是复制粘贴所有的DDL语句从我以前的数据库。另外，我不得不使用'。\SQLEXPRESS'而不是'（LocalDb）\v11.0'

localdb\v11.0 does not support fulltext index. I installed MS SQL Server 2012 express with Advanced Services and it worked like a charm. I had to create an entirely new database again though it wasn't really much of a problem for me as i just copy pasted all the DDL statements from the my previous database. Also i had to use '.\SQLEXPRESS' instead of '(LocalDb)\v11.0' as the server name.

在安装过程中，如果要节省磁盘空间，则只安装搜索的全文和语义提取并保留所有其他功能未选中。

During installation if you want to save disk space then only install Full-Text and Semantic Extractions for Search and leave all the other features unchecked.

编辑：
您可以使用旧的数据库。将旧数据库文件复制到新位置，最好是 C：\Program Files\ Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA
并运行以下sql语句。

You can use your old databse. Copy the old database files to a new location preferably to something like C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATAand run the following sql statement.

CREATE DATABASE databaseName 
    ON (FILENAME = 'C:\Program Files\Microsoft SQL
    Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\filename.mdf'), -- Main Data File .mdf
    (FILENAME = 'C:\Program Files\Microsoft SQL
    Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\filename_log.ldf') -- Log file .ldf

    FOR ATTACH 
GO

这篇关于无法在localdb v\11.0中创建索引目录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

LocalDB