Moving Data Files in 6.5

  • Hi all,

    Please be patient with me as i'm still relatively new to the world of MSSQL.

    Is it possible to move the data files under 6.5? And how would you go about it?

    Thanks in advance for your time


  • There are a couple ways:

    1. Hack the system tables (master..sysfiles).

    Shut down SQL, copy the files, restart SQL. HAck master..sysfiles to change the path of the files.

    2. Make a script to create the new db you want. Backup the old db. Restore to the new db. Delete any physical files and drop the old db.

    Steve Jones

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

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