Results 1 to 2 of 2

Thread: How to move files from c:\dir\f2.mdf to e:\dir\f1.mdf

  1. 10-17-2003, 09:22 AM #1
    copernicus
    copernicus is offline Registered User
    Join Date
    May 2003
    Posts
    35

    How to move files from c:\dir\f2.mdf to e:\dir\f1.mdf

    Hi ,


    I created a few databases but I forgot to change the location from c:\program files\d1.mdf.I don't have much space left on c: drive but have lot of space left on e:

    How do I move the data and log files to e: drive ?

    Thanks,
    Sal
    Reply With Quote Reply With Quote
  2. 10-17-2003, 09:52 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    sp_detach_db and sp_attach_db


    search in this forum for the above or check BOL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules