Home Forums SQL Server 2005 Backups Could not locate file 'SAML' for database 'SAML' in sys.database_files RE: Could not locate file 'SAML' for database 'SAML' in sys.database_files

  • Thanks for responding. I'm back on this...

    I ran: SELECT [name] AS logical_file FROM sys.database_files df

    It returned:

    logical_file

    SPGSAMLDat.mdf

    SPGSAMLLog.ldf

    USE SAML;

    GO

    DBCC ShrinkFile(SPGSAMLLog_log, 3000)

    Msg 8985, Level 16, State 1, Line 1

    Could not locate file 'SPGSAMLLog_log' for database 'SAML' in sys.database_files. The file either does not exist, or was dropped.