Sounds like someone at the source of the chain who provide you with the zip file of the database backup has changed the logical file names.

Chief

sandy-808981 (11/17/2015)

---

Okay ... I think I figured it out. Thank you everybody for your input. I found a tutorial online on how to copy data from one table...

If the current column has none unique values in the range then it can't become the identity unless you manually force the identity_insert value to on.

I would create the table...

From the CE document

Page 39

Stale Statistics

You may determine that the statistics are outdated. This is not necessarily an issue if the data distribution within the statistics object histogram and density...

Can the identity be inserted randomly against the existing data? Or does the data have to follow an existing order for the identity?

If the existing column denotes the order,...

Steve Jones

Issue seems to be down to stale statistics on t1.

The cardinality estimator had its first rewrite since SQL 2000 in the 2014 version.

The following document may help, especially the troubleshooting...

Might be a case of waiting for the ghost cleanup task to kick in, but I wouldn't of thought it would take to long to start the cleanup but depends...

Sorry I meant your script for the FTC drop and recreate.

Did you add in a new filegroup&file when you recreated the FTC or did you use the existing filegroup&files already...

Lau

Can you provide your scripts used?

sys.sysfiles is only included in the product for backwards compatibility.

You should be using sys.database_files.

Does the new system view still show the old FTC?

Complex

Others may come up with other solutions

DECLARE @dayOfBirth datetime = '19850723'

DECLARE @today datetime, @thisYearBirthDay datetime, @years int, @months int, @days int

SELECT @today = GETDATE()

SELECT @thisYearBirthDay = DATEADD(year, DATEDIFF(year, @dayOfBirth,...