I wanted to create a second log file, but by mistake I created a data file.
Now I'm trying to remove it, but I get the error message "the file cannot be removed because it is not empty". The following query lists a lot of tables:
SELECT o.name AS TableOrIndex FROM sysfiles f JOIN dbo.sysfilegroups s ON f.groupid = s.groupid JOIN dbo.sysindexes i ON i.groupid = s.groupid JOIN dbo.sysobjects o ON i.id = object_id(o.name) AND i.indid in (0, 1) WHERE f.name = 'DB_NDF_FILE' UNION SELECT i.name FROM sysindexes i join sysfilegroups f ON i.groupid = f.groupid JOIN sysfiles l ON f.groupid = l.groupid WHERE l.name = 'DB_NDF_FILE'
What's the correct procedure to move these data to other data files so I can safely delete this newly created file?