Home > SQL > Move Database MSSQL to Other Drive

Move Database MSSQL to Other Drive

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

Categories: SQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 57 other followers