Home Dashboard Directory Help
Search

Unable to perform Full Text DDL after reverting from DB Snapshot by J. Granden


Status: 

Resolved
 as Fixed Help for as Fixed


13
0
Sign in
to vote
Type: Bug
ID: 773710
Opened: 12/6/2012 12:21:37 PM
Access Restriction: Public
1
Workaround(s)
view
10
User(s) can reproduce this bug

Description


After reverting to a database snapshot that contains fulltext indexes, you are unable to create any ft_catalogs until you either restart sql server, detach/attach the db, or take the db offline/ set the db online.

This error didn't happen in 2008 ( 10.0.5826.0 )

Microsoft SQL Server 2012 - 11.0.2383.0 (X64)
    Oct 5 2012 19:35:54
    Copyright (c) Microsoft Corporation
    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Details
Sign in to post a comment.
Posted by Microsoft on 4/23/2013 at 7:38 PM
Thanks for reporting the issue. We are currently investigating.
Sign in to post a workaround.
Posted by Seriser6 on 7/18/2013 at 11:59 AM
I do this after my restore snapshot

ALTER DATABASE <dbname> SET OFFLINE WITH ROLLBACK IMMEDIATE
go
ALTER DATABASE <dbname> SET ONLINE
go