Moving Data Files in 6.5

• dragonspirit

  Grasshopper

  Points: 14

  More actions

  September 24, 2001 at 1:59 am

  #57815

  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

  P.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  September 24, 2001 at 1:10 pm

  #418426

  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

  steve@dkranch.net