Table row count throws an exception

Asked Sep 05 '18 at 19:31

Active Sep 05 '18 at 19:56

Viewed 204 times

I have a table named backupfile, this is a copy of sys.backupfile that I am inserting into from all of the servers on in my network.

I was trying to see how big the table has gotten, and when I go to Properties - Storage it takes a while, and then I get this:

It has done this every time I have tried the last few days.

Could my data be corrupt? We run dbcc checkdb weekly.

What could be causing this?

edited Sep 05 '18 at 19:56

asked Sep 05 '18 at 19:31

DForck42

Yeah it's 21GB. Not sure why the row count error - does it happen every time? Only 112MB reported index space would suggest there's no indexes, creating a clustered index might solve it. Also you could try DBCC UPDATEUSAGE – Gareth Lyons Sep 05 '18 at 19:39
@Forrest ahh, yes, that does seem to be the case that it IS 21GB. – DForck42 Sep 05 '18 at 19:55
@GarethLyons there is a primary key on an int, otherwise no other indexes – DForck42 Sep 05 '18 at 19:56
Capturing SSMS (17.5) queries shows that it does a SELECT COUNT(*) FROM table. What happens if you run that query against your table? – Forrest Sep 05 '18 at 20:23
@GarethLyons updateusage has been running for 35 mins now and is still going – DForck42 Sep 05 '18 at 20:38

0 Answers0