Post reply

os_file_name

  • December 11, 2008 at 2:01 am

    #197084

    Dear All

    This is the command :for moving the databases

    ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path\os_file_name' )

    What comes here at "os_file_name" if windows server 2003 is using?

    Thanks

  • December 11, 2008 at 7:37 am

    #911075

    the os name of the mdf, ndf or ldf file you want to move.

  • December 11, 2008 at 10:58 am

    #911231

    You can give any file name which you prefer. Even the same filename is ok because you are changing the path.

    You can verify the modification using sp_helpfile.

  • December 11, 2008 at 11:10 am

    #911240

    Bear in mind that, with the exception of TempDB, running that does not move the files. It just changes the metadata. Once you've run that you need to take the database offline and move the files yourself. Make sure that where you move the files to matches what you changed the metadata to, or the DB will come up suspect when you bring it back online.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 11, 2008 at 9:55 pm

    #911450

    Thancs All...

    Thanks

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

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