Gail,

From that article, did you read the very last part as show here:

It is quite simple to fix this error, but you will need to delete all the Metadata pertaining...

Hi Gail,

>> DBCC SQLPerf(LogSpace)

The above command is returning info that is of no use (that I see) in solving this issue:

How do I tell what log file for db...

Gail,

Here is just one of the articles that you've suggested I throw away. Take a look at the bottom and advise...

http://stackoverflow.com/questions/5946153/why-do-we-need-the-ldf-files-along-with-mdf-files

Thanks, Stanley

>> moved statistics and text/Image data

I don't want to save anything from these filegroups or their tables as I've already copied their image data to its new destination.

For my learning...,...

Hi Gail,

>> No, it's not complaining that the tables are not empty. It's complaining that the file is not empty. There's still an index or a table in that filegroup,...

Hi Lowell,

Running your script returns no records and I see no way of identifying what else is there. I DID explicitly deleted all indexes first before deleting the table....

Gail,

>> You have to drop all tables and indexes that are on the filegroup you want to remove. Not empty the tables, drop them. Once there are no objects...

Check for screenshots now...

Hi Gail,

OK, then how is the best way to get the unneeded ldf files removed while keeping only one?

What I outlined above came from an article I've read somewhere...

Hi Gail,

Would this work?

1. Enter single user maintenance mode

2. Do a files and filegroup FULL backup excluding the unwanted filegroups,

3. detach the database,

4. attach the database with the extra...

Hi Gail,

After individually deleting the indexes and tables that makes up the filegroup they are now removed as this screenshot indicates. The table names were ImagesPDF, ImagesSLA and ImagesTIF...

This...

So, does this mean that I have multiple .ldf files that all belong to the main database and NOT to the filegroup that I was thinking they were to belong...

Hi Gail,

Each filegroup contains a .ndf and a .ldf file and its the .ldf file thats still hanging around. I know you said that .ldf is a log file,...

Thanks Howard,

I believe this is what I need, I'll go and test now...

Thanks, Stanley

Further clarification...

If I were to search and replace all occurances of DRI_KY193 with DRI, the script works without errors.

The DRI database is to be created in subfolder "S:\SQL\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DRI_DATA\"

The...