I have a database with three files
- Primary Data File
- Blob Data file
the database was becoming too big to manage (600GB) so we removed the blob data (500GB) into FileStorage outside the DB.
we then dropped and recreated the Tables into the Primary datafile, following that we ran
Alter Database (db) Remove_File (Blob_Data)
DBCC ShrinkDatabase ('db',10)
. As well as a few other shrinks database properties is still reporting the database size as 600GB.
still remembers the file but it is in the status of 'Offline',
has no mention of the file.
we are currently rebuilding indexes following the shrink, and intend to test the backup and restore process to see if the speed of backup / restore is affected by this.
is this something we need to be worried about? is there any resolution to this?