5009

Product Name

Event ID

5009

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

ALT_BADDISKS

Message Text

One or more files listed in the statement could not be found or could not be initialized

This error indicates that you specified a file name or fileID in ALTER DATABASE or DBCC

SHRINK* command that could not be resolved.

Consider the following scenario:

You have a Microsoft SQL Server database that uses a full or bulk-logged recovery model.

You add a new data file that is named

db_file1

to the database.

You set the file type for the

file as data.

You realize that you specified the file type incorrectly.

You remove the

file, and then you back up the transaction log for this database.

You add a new log file that is named

db_file1

to the same database.

You try to remove the log file that is named

db_file1

by using the ALTER DATABASE

statement or by using SQL Server Management Studio.

In this scenario, you receive an error message that resembles the following:

Msg 5009, Level 16, State 9, Line 1 One or more files listed in the statement could not be

found or could not be initialized.

ﾉ

Expand table

db_file1 db_file1