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

  • September 25, 2012 at 9:20 am

    #1541940

    ran this: SELECT name FROM sys.master_files WHERE database_id = db_id() AND type = 1

    it returned: SPGSAMLLog.ldf

    tried:

    USE SAML;

    GO

    DBCC ShrinkFile(SPGSAMLLog.ldf, 3000)

    it returned:

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near '.'.