Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: changing the data files to another disk partition

    Hi,

    I have a sql server 7 running on a machine with two disk partitions (D: and E.

    The data files xxx.mdf and xxx.ldf are stored in D:, which has very few space available. I want to copy these files to E: but I get an error saying that it is not possible to change the source file of a database. Is it possible to do it or do i have to create another data file in E: and keep the old one in D:?

    Thanks in advance,

    browser

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    sp_detach_db + sp_attach_db ... with (...)

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    detach the database ... copy to new location ... then attach

    or

    backup the database ... restore ... sp_renamedb
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Sep 2003
    Posts
    8
    thanks ms_sql_dba and Enigma, it worked properly!

Posting Permissions

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