Can't delete full text index, also can't rebuild it
I have a database on a remote server running sql server 2013(?) hosted by a hosting company. I decided I would like to be able to use it offline, so I backed it up and ftp'ed the backup to my local PC. I successfully restored it to a local version. I was not able to back up "filegroups" but normally that is not a problem
The problem is that one of my tables has a field called "searchtext" (varchar(100)" which has a full-text index on it. That does not work any more on my local copy (that I administer with sql server 2016).
so I connected to the local copy in SSMS, and clicked on 'storage", then right-clicked on the full text index name, and chose REBUILD. This crashed SSMS.
So I tried deleting the field (the column named searchtext) from the table. This failed, with an error message that the column was enabled for full text search.
So I tried deleting the full text index. That failed too, with a similar error message.
And all this time, I wanted to be bicycling in Tahiti!
Any help is appreciated.
- Changed type Ed Price - MSFTMicrosoft employee Wednesday, January 4, 2017 2:38 AM No response from OP
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
what is the error you are getting?.
Troubleshooting=https://msdn.microsoft.com/en-us/library/ms142595.aspx
Regards, S_NO "_"
------------------------------------
Reply:
SELECT * FROM sys.data_spaces gives this:
name data_space_id type type_desc is_default is_system
PRIMARY 1 FG ROWS_FILEGROUP 1 0
----
SELECT fulltext_catalog_id, name, data_space_id FROM sys.fulltext_catalogs gives this:
fulltext_catalog_id name data_space_id
5 ft NULL
------
SELECT fulltext_catalog_id, data_space_id FROM sys.fulltext_indexes gives this:
fulltext_catalog_id data_space_id
5 1
------------------------------------
Reply:
Please click "Mark As Answer" if my post helped. Tony C.
------------------------------------
Reply:
Hm, then you only seem to have one filegroup. (And you did run this on the copy that is at the hosting company? Then again, if you had multiple filegroups, this would exhibit here anyway.)
OK, then we need to see the exact messages for the operations you are making. Forget about SSMS crashing - run the rebuild directly from T-SQL:
ALTER FULLTEXT CATALOG ft REBUILD
------------------------------------
Reply:
Sorry for the delay in replying.
I got the error message:
Msg 7641, Level 16, State 2, Line 1
Full-Text catalog 'ft' does not exist in database 'master' or user does not have permission to perform this action.
As far the other suggestion of disabling some file type checking in my anti-virus, I'd rather not do that for safety reasons, and also, SSMS should work no matter what anti-virus I'm using.
------------------------------------
Reply:
Sorry for the delay in replying.
I got the error message:
Msg 7641, Level 16, State 2, Line 1
Full-Text catalog 'ft' does not exist in database 'master' or user does not have permission to perform this action.
In that case you are hanging out in the wrong database. "master" is the main system database in SQL Server. Run the command from your own database.
------------------------------------
Reply:
I got rid of the permissions error with a USE statement (for the correct database), but now I get this error:
Msg 7644, Level 17, State 1, Line 4
Full-text crawl manager has not been initialized. Any crawl started before the crawl manager was fully initialized will need to be restarted. Please restart SQL Server and retry the command. You should also check the error log to fix any failures that might have caused the crawl manager to fail.
My lines were:
USE DB_1544_salvage
ALTER FULLTEXT CATALOG ft REBUILD
------------------------------------
Reply:
------------------------------------
Reply:
I looked at the log, but I did not understand what I saw in it. I then found a web-page on that particular error, which I will read this afternoon.
Thanks.
------------------------------------
Reply:
------------------------------------
Reply:
- Edited by rating maven Sunday, September 25, 2016 12:24 PM
------------------------------------
Reply:
Rating, is this still an issue?
Thanks!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Insider buid 14986 is now available in SLOW ring.... for PC only.
Excerpt:
UPDATE 12/14/16: We have released Windows 10 Insider Preview Build 14986 for PC only to Windows Insiders in the Slow ring.
- Edited by david hk129 Wednesday, December 14, 2016 9:03 PM
- Changed type Kate LiMicrosoft employee Friday, December 30, 2016 7:08 AM
Reply:
Thanks for sharing, we appreciate that. I would like to introduce it to other community members.
Best regards
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
The Backup Job to tape failed for the following reason (ID3311)
We are running System Center 2012 r2 DPM, MS Server 2012 R2 and HP tape library. Device Manager reports that the medium changer is HP LTO Ultrium-6 drive.
DPM recognises the tape library and drives and will perform the basic operations, importing/exporting/moving/erasing media bit will not backup. The full error code is as follows: Description: The Backup Job to tape failed for the following reason (ID3311) Detailed Errors: The operation failed because of a protection agent failure (ID 998 Details: Access is denied (0x80070005))
Recommended Action: Run Backup to tape job again...
I have tried changing the default drivers for the tape unit to the Microsoft LTO driver and it made no difference.
I have run the job again but it still fails. I have reinstalled the agent on the remote computer and have recreated the protection group, all of which fail.
Anyone have any suggestions to get this going again?
Thanks
Bill
Reply:
We've had a case open with Microsoft for 3-4 months now with zero success and a LOT of ridiculous suggestions being made by their side.
We have Dell TL2000 devices (5-10 of them across 10 different offices) with LTO6 drives in them and they are all reporting the same error you're seeing. All are running on Server 2012 R2.
We've changed firmware, drivers, uninstalled additional software, upgraded to DPM 2016 RU1, been escalated, etc. Still no success.
If you happen to have any luck please let me know. I won't hold my breath though.
------------------------------------
Reply:
Hi Zmottie -
I never heard anything back from anyone either. What I have found I have to do is do a full erase on the tape(s) before my backup runs. Once I do that they run with no issues. If I do not erase them then I get the same errors as you.
Regards
Bill
------------------------------------
Reply:
Are you manually erasing tapes or have you configured DPM to erase tapes before re-using them?
Anything you could share about your configuration/settings would be helpful.
------------------------------------
Reply:
Hi Zmotie - I am doing a manual erase. Only because I trust it and know I can check it before the backups start. I am not even sure where or how to set it to automatically erase the tapes. I sort of fell into this after being very frustrated a couple months ago and tried the erase and it worked. I wish there was a easier way.
------------------------------------
Reply:
Hi,
We have seen some 3rd party tape drivers cause that error, but you should never have to manually erase a tape, so that is weird.
Please try using the Microsoft in-box ltotape.sys drivers for the tape drive(s).
1) Open device manager
2) Locate the tape drive
3) Right-click and look at the properties.
4) Under the DRIVER tab, select UPDATE DRIVER
a) Select the Install from list or specific location (Advanvced) - next.
b) Select Don't search. I will choose the driver to install. - next.
c) Uncheck the Show comtabile hardware checkbox.
d) Highlight LTO under the manufacturer.
e) Highlight the LTO tape drive under model - then next.
f) This should install the Microsoft ltotape.sys driver 5.2.3790.0 or higher.
5) Rescan the tape library in the DPM console, if a duplicate tape drive appears, then run the following utility.
c:\program files\Microsoft_dpm_Install_path\DPM\DPM\bin\DPMDriveMappingTool.exe to remap the tape drive and remove the duplicate
6) Now inventory the library and try a new backup.
If you want to automate erasing expired tapes - you can download the dpmtapeutil script from here and run the following command.
This will Schedule tapeerase tape for expired tapes every 1 day at 10:00am
.\dpmtapeutil.ps1 -search "state=recyclable" -tapeerase –schedule "Enable|daily|1|10:00"
NOTE: Before using the dpmtapeutil.exe to erase tapes, please implement this registry key.
Short Erase
http://technet.microsoft.com/en-us/library/ff634195.aspx
When a user erases a tape, by default, DPM will do a long erase on that tape. DPM 2010 has introduced the ability to do a short erase now. Simply navigate to the following registry location and add the DWORD key with the default vale:
HKLM\Software\Microsoft\Microsoft Data Protection Manager\Agent
REG_DWORD:UseShortErase:0x0
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
------------------------------------
Reply:
Mike Jacquet if it's at all possible can you (or someone on your team) please review case 116061414289056.
The number of changes/changes that the support team had to do was, frankly embarrassing.
The next step according to them was to completely wipe our servers, upgrade the OS and reinstall DPM from scratch. That's after uninstalling other products, removing antivirus, adding disk based backups, changing libraries, deleting recovery points, etc etc. Baffling.
You came up with the answer (using in-box drivers) within seconds. Every time I've had a DPM problem the support has been god awful and I'm fairly certain you have solved every single one of my issues after we've dealt with the 'proper channels' for far too long.
I suppose I should have learned to simply ask here by now... shame on me!
------------------------------------
Event Id 2017 The server was unable to allocate from the system nonpaged pool because the server reached the configured limit for nonpaged pool allocations.
HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\LargeSystemCache
and set the following registry key to ‘3′:
HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\Size
After making these changes and restarting, I haven’t seen this issue arise again
- Changed type Nicholas Li Friday, February 12, 2010 2:49 AM
Reply:
Hi,
Thank you for your sharing. I hope this information will benefit some other users who meet the similar issues.
Nicholas Li - MSFT
------------------------------------
Reply:
------------------------------------
Reply:
Lyle Epstein
Kortek Solutions
http://www.korteksolutions.com
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
I knew this needed to be done from prior experience but forgot to note the specifics. Thanks for the concise, helpful post that Google turned up easily with the search string:
nonpaged pool allocation limit windows 7
-Noel
| Detailed how-to in my eBooks: | Configure The Windows 7 "To Work" Options |
------------------------------------
Reply:
Bonnie Whalon
------------------------------------
Reply:
------------------------------------
Reply:
Thank you krbaugh for your contribution.
I would just like to add that on a "client" machine this error seams to appear if one has at least one "Maped Network Drive" that dose no longer exist. This is not to be mistaken for a disconnected drive! The client is desperately attempting to reach the drive, which it believes to still be their. I am not sure if the Registry edits you proposed help the client to stop looking for drive(s) that no longer exist.
------------------------------------
Reply:
I can also confirm that QuickBooks error code 6150 and 1006 can be cause directly by multiple disconnects from the QuickBooks server. The user account was corrupted so I had to recreate it and I was also seeing (Event 4 QuickBooks-Event Viewer). The above fix took care of the connection issues and user accounts are no longer being corrupted.
Thanks for the post it saved me a lot of time on the phone having a useless conversation with Intuit.
- Edited by CurrinJ Wednesday, December 14, 2016 5:52 PM Grammatical
------------------------------------
Babielato
double a, b, h, pole, suma, x;
int n;
a = Convert.ToDouble(textBox1.Text);
b = Convert.ToDouble(textBox2.Text);
n = Convert.ToInt16(textBox3.Text);
h = (b - a) / n;
pole = 0;
suma = 0;
x = a;
for (int i = 0; i < n; i++)
{
switch (comboBox1.SelectedIndex)
{
case 0: pole = h * y(x);
break;
case 1: pole = h * y(x + (h / 2));
break;
case 2: pole = (h / 2) * ((y(x)) + (y(x + h)));
break;
case 3: pole = (h / 2) * ((y(x + (h / 3))) + (y(x+((2 * h) / 3))));
break;
}
x += h;
suma += pole;
}
textBox4.AppendText(suma.ToString() + "\r\n");
}
}
}
Reply:
Hi, babielato!
What is your question ?
------------------------------------
Reply:
Watch out for potential divide by zero errors on line:
h = (b - a) / n;
Paul Herber, Engineering and software shapes for Visio<br/> <a href="http://www.paulherber.co.uk/">Paul Herber</a>
------------------------------------
Printing is not available. Verify that ActiveX is enabled, or try using Internet Explorer for the desktop.
Welllll....the second part is probably not going to happen..."or try using Internet Explorer for the desktop"....Because we are using Citrix to access our company-wide applications. What we did do was save our Production Report Manager Portal URL web page as a Wepage.complete .html and then drop that into our "PROD" folder file structure that they can get to. When our business users <Click> on the .html, it is indeed bringing up the Production Report Manager Portal that allows the end business users to access Production Report Manager Portal and their reports and execute them properly.
We get this windows dialogue box when attempting to print the report.
Is there any way around this? Like I said, the Internet Explorer option is not an option because they're really not utilizing Internet Explorer.
Is this "ActiveX" a setting within the Report Manager set-up?
Are we really going to have to save as a PDF and print that way?
Any help or guidance would be GREATLY appreciated. Thanks for your review and Thanks in advance for any help and/or guidance you can provide.
Project Pro for Office 365 Recurring Tasks Anomalous Behaviour
Has anyone else encountered the following.
I am using Project Pro for Office 365 and when creating a Recurring Task the scheduling tool wilfully refuses to schedule my recurring tasks in line with their definition - see attached screenshot, I define the recurrence as every 2 weeks on a Tuesday - Project Pro decides to schedule them every week on a Wednesday. I have never encountered this before and have encountered it with 3 different instances of Project Pro for Office 365.
With good wishes,
Dominic
Microsoft Project Evangelist
Twitter:
Reply:
Hi Dominic,
I can't reproduce this issue, it works as expected on my Project version: 16.0.6701.1041 (not up to date).
Hope this helps, Guillaume Rouyre, MBA, MVP, P-Seller
------------------------------------
Reply:
With good wishes,
Dominic
Microsoft Project Evangelist
Twitter: ------------------------------------
DFSR Group Extraction
Hello,
Any can help me to extract all DFS and DFSR group and PRIMARY Server for those groups we have almost 500 plus DFS and DFSR group available, I would like to get the report on daily basis.
Do we have any script that can be send daily basis report.
D.K Konar. NMS
Reply:
Wrong forum.
Mods - can you please move.
Cheers,
Rhoderick
Microsoft Senior Exchange PFE
Blog:
http://blogs.technet.com/rmilne Twitter: 
LinkedIn: 
Facebook: 
XING: 
Note: Posts are provided "AS IS" without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.
------------------------------------
Configuring the order in which folder items are displayed
Is it possible to configure the order in which elements within a folder appear when using VSAE?
Right now i've made the folder and then created a number of views within it. The problem I have is that they just seem to appear in alphabetical order and i'd actually like to stipulate which order the show in.
Thanks
Pete
Reply:
I've already seen it done in Microsoft MPs using numbers in front of views' names (like 1 - Server, 2 - Performance etc).
Not sure if you can do it another way
------------------------------------
MIM 2016 Sync Installation
Hello All,
Need Help!
We are upgrading to MIM sync 2016 in our environment. We have a database deployed in a clustered environment on SQL Server SP1
Problem is while installating MIM sync service , the moment i provide server name and instance name it gives an attached error.
The port configured as per the SQL team is 52608 and not the default one 1433/1434 for the DB connection.
As MIM 2016 is by default use the port 1433/1434, then how can i proceed my instllation.
Please Suggest.
Regards,
Suman
Reply:
Helo Suman,
What i personally always do is create a SQL alias for MIM to use, which has the added benefit of moving the database to another server much easier. In the alias you can specify the port and the server name.
You do this by opening the SQL server configuration manager, going to aliases and creating a new one.
I have added a screenshot for reference:
Hope this helps,
Joren
- Edited by Joren Van Camp Wednesday, December 14, 2016 2:28 PM
------------------------------------
Query to sent messge from system context to logged in user
1,
We are writing a script which require some messge to be sent to the other users who also logged in to the same computer.
When other user login then he should see the mesage
2 ,
Is there a way to copy a file using system context process to currently logged in user context ?
3, We are installing a application on a computer using system context which require a logoff and login...We tried message box prompt but it is not visible for user session... how can i sent this message from system context to logged in user context.
verification
- Changed type Bill_Stewart Friday, February 17, 2017 4:03 PM
- Moved by Bill_Stewart Friday, February 17, 2017 4:03 PM Unanswerable drive-by question
Reply:
Read this first:
This forum is for scripting questions rather than script requests
-- Bill Stewart [Bill_Stewart]
------------------------------------
about error code80096004
Reply:
Simon Dettling | msitproblog.com | @SimonDettling
------------------------------------
Skype online migration Rollback strategy
Hi all ,
I need to migrate all my existing Lync 2013 users to Skype Online . There is a lot of sensitive user data that i am dealing with here . What is the best rollback strategy that i should adapt for carrying out my migration . Any help would be appreciated .
- Changed type RB27 Wednesday, December 14, 2016 5:09 AM
Reply:
Hi RB27,
Welcome to our forum.
If there are Exchange servers in organization, we suggest you configure Exchange to integrate with Lync server 2013, then archive user data into user mailbox. The following step is to migrate Lync server 2013 to SFB online and configure SFB online to integrate with On-premise Exchange server.
If you don't have Exchange in organization, after we create hybrid, Lync data will be encryption to migrate to SFB online and you don't worry about it.
If there are any questions or issues, please be free to let me know.
Best Regards,
Jim Xu
TechNet Community Support
Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
Implementation of Windows 10 OS
Hi everybody,
I have a general question, I am planning to implement Windows 10 to our company.
Can anyone give me tips on what I should keep an eye on, or when I have to be careful with Windows 10. I already did a lot of brainstorming, but I think it is good to hear suggestions from other people too.
Thank you very much in advance!
Regards,
Nikolai
- Changed type MeipoXuMicrosoft contingent staff Thursday, December 15, 2016 9:40 AM
Reply:
Hello Nikolai,
We purchased 110 Dell AIO (all in ones). We had several issues with Dell Service Assist and many other issues. Whether you buy from Dell or a re seller you will want to make sure all updates, BIOS, drivers and windows are completed before connecting to the network. I updated one and used Clonzilla to image the rest.
Best wishes,
Mark
------------------------------------
Reply:
Also, W10 does not have a media player so plan on installing a player like VLC from
https://www.videolan.org/vlc/
Mark
------------------------------------
Reply:
------------------------------------
Reply:
Thank You!
Yep, I recognized it a vew weeks ago, we are already running VLC on Win10.
------------------------------------
Reply:
I'll add it to my list :)
------------------------------------
Reply:
------------------------------------
Reply:
Hi,
If you are the IT administrator, this article may help you, please refer to the link:
Five Basic Windows 10 Computer Skills Every Engineer Should Know:
Please Note: Since the websites are not hosted by Microsoft, the links may change without notice. Microsoft does not guarantee the accuracy of this information.
Best Regards,
Tao
Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
Setting NLB with different hardware specification
Hi All,
I want to ask how to make best setting NLB with different hardware specification.
ie. I have 2 servers and these will be on one cluster & NLB, server A has 32 GB and server B has 16 GB memory of ram.
thanks.
Reply:
Gleb.
------------------------------------
New: Windows 10 for Business Onboarding Kit
For Version 1511 users : You have a new cumulative update KB3205386
Windows 10 Version 1511 ONLY.............
KB3205386 has been released. It will push your OS build to 10586.713
https://support.microsoft.com/en-us/help/4000824
- Edited by david hk129 Wednesday, December 14, 2016 5:40 AM
Bug Report! Error ID: 27005 when adding SCOM SSRS to SCVMM. Misspelling in code. System Center 2016 TP5 Latest Build
SCOMASRS Log with Error:
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Microsoft.SystemCenter.VirtualMachineManager.2016.Reports/Microsoft.Virtualization.2106.Reports.ForecastMachineGroupDiskIO' cannot be found.;
Somebody flubbed 2016, in the code it reads 2106! Temp workaround is to change name of resource to 2106 to match code.
- Edited by E. Hilton-Syntek Wednesday, October 19, 2016 6:20 PM
Reply:
Hello,
Could you please let know which version of MP u r using. Is it 10.0.5.0 or 10.0.6.0? R u on SC 2016 RTM or UR1?
Kaushik
KAUSHIK BHATTACHARYA
------------------------------------
Font size becoming too big
We are experiencing a strange issue. some times when our users are receiving emails in outlook, some part of the text is becoming very big while the rest of it is the normal size.
we confirmed with the sender when they sent the email it was in normal font size but after receiving it on our end, the problem arises.
we experienced this in outlook 2010 and outlook 2013. please check the below screen shot. we have blurred the text which is in normal size.
Second email
---------------------------------------------------------------
Reply:
Do you have a question? If so, please change the thread type to a question instead of a discussion.
I recommend that you post this in the Outlook Forum: http://social.technet.microsoft.com/Forums/en-US/outlook/threads
Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
Celebrating 20 years of providing Exchange peer support!
------------------------------------
Web Analytics Reports Outcome "Email sent but reports with no data were not attached."
Hi all,
I am having an issue with some web applications in SP2010 Enterprise where workflows are set for web analytics to send reports. Outgoing email is set up correctly, accounts have emails associated with them, and the report emails work fine when started manually (they include the Excel file attached). The problem is when the report workflow is kicked off from the timer job, the email is sent, but the Excel report is not attached and the email states "No weekly Web Analytics reports for <startDate> through <endDate> for SharePoint Site <siteURL> were sent because there was no data for this date range/ there were errors. For error details, see the server ULS logs." i checked the ULS logs and there are no errors. Workflow Histor shows the same error as the email "Email sent but reports with no data were not attached."
I double checked the date range and there is data there which is sent when started manually. Also, since it is working when started manually, but not with the timer job I was thinking it was permissions. I have checked and the app pool account for the web app, the app pool account for the service app, and the server farm are all on the Web Application Service App and have permissions to the site itself that should give it access to the reports.
Other sites on the server in other web applications are sending the reports as expected with the timer job. I compared everything I could think of between permissions and settings to confirm they were the same.
Any thoughts on what might resolve this?
Thanks,
J.
No comments:
Post a Comment