Post reply

sysfiles has wrong info for DB

  • January 17, 2005 at 3:18 pm

    #163513

    This server host a production copy and test copy of the DB. There are files for both DBs live and test. When I run select name from sysfiles for the test DB it returns file names for the live DB. The live DB returns the correct file names. Could the test DB be running off of the live files also? And how do I correct this problem? I found this out because I need to shrink the log file.

    Thanks

    Frank

  • January 17, 2005 at 3:33 pm

    #537744

    Frank,

    Are you talking about the Name field which is the logical name and could be the same or about Filename field which is a path and should be different?

    Regards,Yelena Varsha

  • January 17, 2005 at 3:44 pm

    #537746

    Hopefully, this will clear it up because it is confusing me. I ran DBCC Shrinkfile and it would return that it could not find the log file. So I ran the 'select name from sysfiles' command and it returned the file names for the live database and not the test database which I was working with. I believe that is the logical name is what it returns. So am I overreacting to this? How do I shrink the log file then?

    Thanks for the help.

    Frank

  • January 17, 2005 at 3:53 pm

    #537749

    I ran select filename from sysfiles and it did return the correct file path and files for the test DB. So it is just the logical name itself that is goofed up. That is what I need to fix so I can shrink the log file.

    Thanks

    Frank

  • January 17, 2005 at 8:28 pm

    #537765

    This can get very confusing as you move databases around.  To correct the problem use this command:

    alter database dbname  MODIFY FILE (NAME = logical_file_name, NEWNAME = 'new_logical_name')

    You don't have to correct the name to shrink the files.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • January 18, 2005 at 9:33 am

    #537871

    Worked like a charm.

    Thanks

    Frank

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply