Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: Sysaltfiles , how can i remove a file

    I'm taking the Administration of a DB wich it has on system table sysaltfiles some leftoff files that are not being used anymore on TempDB,

    how can i remove them ? Every time i restart the SQL Service it tries to open those files on sysaltfiles..

    I tried ALTER DATABASE tempdb remove file XXXX , it did not work...

    I got this error:

    ALTER DATABASE failed. Some disk names listed in the statement were not found. Check that the names exist and are spelled correctly before rerunning the statement.

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Did you delete them manually?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts