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

No comments: