473,783 Members | 2,563 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Full-text indexing failed after DB move

1 New Member
Hello to everyone out there. I am a non SQL person TRAPPED in a nightmare!

The long short is we have a CRM 3.0 database that is running in SQL 2005 on a Windows 2003 SP1 Server. (HP ProLiant ML350 3.0ghz 3.5gb RAM)
Server started running out of drive space and could not hold transaction log. Would basically lock up everyones sessions until flushed. Put a cap on log size until drives could be purchased and installed. Perfomance suffered during waiting period but became manageable after playing with cap size.

Installed a pair of 146gb 15k hot swap SCSI drives in RAID 1+0 array in addition to existing RAID 5 drive set. Moved DB and log file to new drive and released log file cap. Only noticed marginal performance improvement and only for about a day. Moved log file to different drive but original testing seemed like it did not make an impact. Then discovered that the Full-text indexing or Transactional Maintenance has not completed since over a week ago. Played with maint. jos in Enterprise Mgr but cannot figure out problem. Including Event Application Manager log as well as capture of maint. job details.

Sales force is REALLY starting to grumble about response time and reboots. I fear they will storm my office soon! ANY info will be greatly appreciated.
thnx in advance, SQLDUMMY

Event Log
Date 7/30/07 Source: SQLSERVERAGENT
Time: 10:03pm Category: Job Engine
Type: Warning Event ID: 208

SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'MSCRM Maintenance Plan'' (0x01B0157901B7 5E4BB0E1E518157 1E116) - Status: Failed - Invoked on: 2007-07-30 22:00:00 - Message: The job failed. The Job was invoked by Schedule 33 (Schedule 1). The last step to run was step 1 (Step 1).

FT Indexing Job Details
Step Name: Full-Text Indexing
Type: Transact-SQL Script (TSQL)
Database: "name of our MSCRM database"
Command: use "name of our MSCRM database" exec sp_fulltext_cat alog N'ftcat_documen tindex", N'start_increma ntal'

Error log contains:
2007-08-07 22:10:00 - ! [298] SQLServer Error: 4060, Cannot open database requested in login 'SteelMaster_Bu ildings_LLC_MSC RM'. Login fails. [SQLSTATE 42000]

Looked up error and found
CAUSE
The Expired Subscription Cleanup job executes the sp_expired_subs cription_cleanu p stored procedure within the context of the first database that was published. The sp_expired_subs cription_cleanu p stored procedure tries to run under the context of the database that was dropped but the procedure fails. BUT CANNOT FIGURE OUT WORKAROUND STATED HERE.


DB Transaction Maint Job Details
Step Name: Step 1
Type: Transact-SQL Script (TSQL)
Database: master
Command: EXECUTE master.dbo.xp_s qlmaint N'-PlanID 416FC9E9-39B6-4A43-B5E8-7109EC15E147 -Rpt "D:\SQL Backup\MSCRM Maintenance Plan6.txt" -DelTxtRpt 3DAYS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "D:\SQL Backup" -DelBkUps 3DAYS -CrBkSubDir -BkExt "TRN"'

Error log contains:
[3] Database ReportServer: Transaction Log Backup...
Destination: [D:\SQL Backup\ReportSe rver\ReportServ er_tlog_2007080 80747.TRN]

** Execution Time: 0 hrs, 0 mins, 1 secs **

[4] Database ReportServer: Verifying Backup...

** Execution Time: 0 hrs, 0 mins, 1 secs **

Backup can not be performed on database 'ReportServerTe mpDB'. This sub task is ignored.
Aug 8 '07 #1
0 1938

Sign in to post your reply or Sign up for a free account.

Similar topics

0
3827
by: daking | last post by:
I'm trying to track down a Java performance issue, and believe it may be related to GC behavior. Quick background: j2se app server running Caucho Resin 2.1.12, on RHEL3 with Sun JDK 1.4.2_04, modest number of threads, serving approx 50-150 requests per second. The system runs as expected until the first Full GC, which happens as normal, when the heap has reached near full. .... 9235.733:
0
5162
by: reneecccwest | last post by:
SELECT d.code, d.description, v.code AS divCode, v.descripton AS divDescript, b.code AS brhCode, b.description AS brhDescript FROM Department d FULL OUTER JOIN Division v
7
6237
by: alexcn | last post by:
I have the following query: SELECT dbo.tSymExch.exCode, dbo.tSymGrp.sgCode, dbo.tSymMain.smCode FROM dbo.tSymExch FULL OUTER JOIN dbo.tSymGrp ON dbo.tSymExch.exID = dbo.tSymGrp.sgexID FULL OUTER JOIN dbo.tSymMain ON dbo.tSymGrp.sgID = dbo.tSymMain.smsgID Which produces:
2
4411
by: Larry R Harrison Jr | last post by:
I have pull-down menus in javascript and I have the code for opening a link in a new window. But I want it to open a full-sized window. I can't figure out the syntax. What I have so far: Menu5_5_1=new Array("'Lonely Church","javascript:window.open ('http://www.photo.net/photodb/photo?photo_id=2640310')","",0,20,300); That works fine, except I can't figure out how to modify it to make it open full-screen.
1
3201
by: onewebclick | last post by:
Is there a way to detect a browser cache is full using javascript or HTML thorugh a web page and inform the user to clear the cache to improve performance of the website. It looks like google's gmail use to detect and warn "Gmail says my browser's cache is full" http://gmail.google.com/support/bin/answer.py?answer=14106 then there should be a way to do it if google can do it. Any thoughts ?
8
4605
by: Sean Shanny | last post by:
To all, The facts: PostgreSQL 7.4.0 running on BSD 5.1 on Dell 2650 with 4GB RAM, 5 SCSI drives in hardware RAID 0 configuration. Database size with indexes is currently 122GB. DB size before we completed the vacuum full was 150GB. We have recently done a major update to a table, f_pageviews, in our data warehouse. The f_pageviews table contains about 118 million rows.
1
3484
by: Jimmy Chen | last post by:
Recently I've done a db2 backup and restore/recovery, but the process for recovering the database was different than what I thought to be. here is what I did: DB2 is set in online mode - backup - * backup db2 in full * insert record
2
5089
by: Lee | last post by:
I have two identical schema tables (one in a production library and another in a development library) and I need to be able to easily compare the data in them for errors and omissions. With another relational database (can you guess which?) I was able to do the following: SELECT * FROM tableA A FULL OUTER JOIN tableB B ON A.KEY=B.KEY WHERE A.KEY IS NULL OR B.KEY IS NULL OR A.DATA<>B.DATA I am trying to do the same thing on DB2 v5r3...
11
8298
by: rh00667 | last post by:
hi all, i'm confused now. how i can get the full path of an application? if myapp is in a directory which belongs to PATH, argv gives me the first token of cmd line, and not the real path of the executed program. so if i write anywhere:
4
18236
by: Brian D | last post by:
In MS SQL 2005 when you do a Full Backup does it also backup and truncate the transaction logs or do I need to back the transaction logs up separately? Thanks. Brian
0
9643
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9480
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10147
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8968
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7494
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5379
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5511
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4044
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.