?
Solved

SQL 2008 server indexes dissappears

Posted on 2016-11-02
5
Medium Priority
?
24 Views
Last Modified: 2016-11-08
Hi

We have some indexes that seems to disappear without any interaction from us.

One of the indexes is created like this (it has disappered 4 times last month)

      CREATE NONCLUSTERED INDEX IDX_WMSORDERTRANS_HTSYSTEM
      ON [dbo].[WMSORDERTRANS] ([EXPEDITIONSTATUS],[DATAAREAID])
      INCLUDE ([INVENTTRANSID])

To us it looks standard but still it disappears?

/Henrik
0
Comment
Question by:HenrikVang
  • 3
  • 2
5 Comments
 
LVL 38

Expert Comment

by:Pawan Kumar
ID: 41869774
Some one must have deleted the index - Manually/Via Job/Script. I dont think index just disappears.

Try this and see if exists

SELECT * 
FROM sys.indexes 
WHERE name='IDX_WMSORDERTRANS_HTSYSTEM' AND object_id = OBJECT_ID('WMSORDERTRANS')

Open in new window


Are you the DB Owner ?
0
 
LVL 38

Assisted Solution

by:Pawan Kumar
Pawan Kumar earned 2000 total points
ID: 41871572
Hi HenrikVang,

Any update on this?

Regards,
Pawan
0
 

Accepted Solution

by:
HenrikVang earned 0 total points
ID: 41871826
Hi Pawan
I just found the solution - our AX2009 cleans all indexes when a table is updated and create only the indexes that is registred in AX and not the ones that was created in SQL management

/Henrik
0
 
LVL 38

Expert Comment

by:Pawan Kumar
ID: 41871831
Yes see i told you!! Some one must have deleted the index

Great Enjoy!

Bye
Pawan
0
 

Author Closing Comment

by:HenrikVang
ID: 41878486
The solution has nothing with sql server do do
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question