Wednesday, 22 May 2013

Link : Move Database Data Without Taking the Database Offline

This article shows how you can move database data to a new .MDF data file via the ALTER DATABASE and DBCC SHRINKFILE commands.

  1. Can be done online 

  1. Speed 
  2. Cannot move system objects 
  3. Index Fragmentation may be caused