Move Database MSSQL to Other Drive

Posted: January 5, 2012 in SQL

1. Detach your database want to move

clip_image002

2. Check all (Drop, Update, Keep) then ok

clip_image004

3. Select database you want to move use cut or copy

clip_image006

4. Paste to other drive

clip_image008

5. Open MSSQL Management Studio – Database -Attach

clip_image010

6. Add your database

clip_image012

clip_image014

clip_image016

clip_image018

clip_image020

clip_image022

CMIIW … Thank you J

Leave a Reply

Your email address will not be published. Required fields are marked *