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.

Pros
  1. Can be done online 

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