Post reply

SP_HELPDB giving wrong filenames on standby databases

  • September 25, 2009 at 4:33 am

    #215624

    Hi all

    Has anyone seen this happen on 2008?

    Restore a database to standby - sp_helpdb and sysfiles show the oringinal database file names and paths, but sysaltfiles shows the right ones...

    Have I missed a patch - or is this just the way its going to be on 2008?

    Cheers

    Rich

  • May 25, 2014 at 10:02 pm

    #1716420

    Hi,

    I see the same error in SQL 2008 for databases restored on secondary. sp_helpdb still shows the location of the primary db files. Any ideas on this?

Viewing 2 posts - 1 through 1 (of 1 total)

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