tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

Published 20 hours ago • verified publisher icon microsoft

usp_AdaptiveIndexDefrag - Database does not exist error on SQL 2017 database.

Open d-moloney opened this issue 4 years ago • 2 comments

Selecting a statistic to update... Getting information on selected statistic... Determining modification row counter for statistic [PK_spotlight_playback_data] on table or view [spotlight_playback_data] of DB [SpotlightPlaybackDatabase]... Using sys.dm_db_stats_properties DMF... Error 911 has occurred while determining row modification counter. Message: Database '[SpotlightPlaybackDatabase]' does not exist. Make sure that the name is entered correctly. (Line Number: 1)

Any help?

d-moloney avatar Apr 02 '20 12:04 d-moloney

Same on SQL 2019.

AGirin avatar Apr 28 '20 21:04 AGirin

Solution here worked for me (second comment):

https://github.com/microsoft/tigertoolbox/issues/166

AGirin avatar Apr 28 '20 21:04 AGirin