Wednesday, March 28, 2012

Move Database from one disk to other

Method 1
  • Detach the database
  • Move the file to other disk 
  • Attach the DB
Method 2
  • Backup the database
  • Drop the database
  • Restore database specifying location of data and log file to other disk.

No comments:

Post a Comment