Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53

    Unanswered: Moving Datafile on SQL Server 7.0

    Hi All,

    I have a database -- MDB -- with datafile for data and transaction log under the folder d:\mssql\data . Now i want to move the data file from d:\ to e:\, say e:\mssql\data . Can someone let me know if this is possible under SQL server v7.0 and if so, how

  2. #2
    Join Date
    Nov 2004
    Posts
    3

    Moving Datafile on SQL Server 7.0

    Yes, you can do this by backing up the database and then restoring using RESTORE DATABASE with the WITH MOVE option. There you can specify where the files are recreated.

  3. #3
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53
    i found another way to do this . Using sp_detach_db and sp_attach_db builtin procedures

    Here's the link from microsoft support site, which gives the details of this

    http://support.microsoft.com/default...b;en-us;224071

    Thanks everyone for your time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •