No, just remove the norecovery option,
restore ended afert 9.55 h with these messages:

Msg 3009, Level 16, State 1, Line 2
Could not insert a backup...

no new entry in errorlog, differential restore still running
this is the first rows of exec xp_readerrorlog 0,1, N'',N'',null,null,N'desc'
2017-03-08 11:23:42.290 spid58 Recovery completed for database dbxxxxx (database ID 5)...

just tried to rebuild the pk of an empty table (the one in the first example)
after the rebuild dbcc ind (0,'xxxxxx,1) returns different result:
9208    17    NULL    NULL    305268216    1    1    72058211345760256    In-row data    10    NULL    0    0    0    0
9208    16    9208    17    305268216    1    1    72058211345760256    In-row data    1    0    0    0    0    0

edited only table name, can run checkdb now, copy errors from maint_plan log:

Failed: (-1073548784) Executing the query "DBCC CHECKDB(N'dbxxxxxxxx') WITH NO_INFOMSGS
" failed with the following error:...

sorry to back in topic, but the DB shutdown will be next week (it happens 1-2 times per years).

in these days i've checked for gam/sgam/pfs on tempdb and found some,maybe...

i made a batch script with sqlcmd, not the best, but it do what i need 🙂

the loop part:

FOR /l %%i in (1,1,%LOOPS%) DO (

cls

time /t

date /t

echo %INSTANCE%

echo.

SET /A CNT-=1

ECHO...

thanks for reply, but i need something different.

my goal is to create a real time session monitor (select on check_active_sessions)

that at every loop clear the output and display the nwe...

server has 48 cpu and

x: is 1TB, "semi dedicated" for tempdb, raid 10

(the big and heavy loaded database files are on another nas)

I sized the datafiles based on current size...

there is only that table in this DF,

btw i've done the job

resize step by step without causing locks

I do all the maintenance tasks (rebuild nonclustered indexes and reorg pk...

i use this settings:

SKIP, NOREWIND, NOUNLOAD, COMPRESSION

BUFFERCOUNT = 2200

BLOCKSIZE = 65536

MAXTRANSFERSIZE = 2097152

my 8hours backup (1Tb compressed) now is done in 1:20Hours, at 800mb/s

check memory usage before set this...

indeed not a big problem, I would take advantage of a maintenance window i've obtained for this db to resove also this situation,

ty all for the support

ty all,

i've followed ms procedure yet, this is the situation:

select * from sys.filegroups

where name like 'fg_to_delete'

fg_to_delete 93 FG ROWS_FILEGROUP00 ....

select * from sys.database_files where data_space_id = 93

94D...FB979AE700ROWS93filenametodelX:\db\filenametodel.mdf 7DEFUNCT

alter database...

it's a cul de sac

when i try to put file offline:

"Cannot add, remove, or modify file 'v_427_COMMONS' because it is offline"

indeed it is in "7DEFUNCT" state, the file doesn't exists...

ok, that is no good, so there's a way to get rid of this defunct filegroup?