Tag: Procedure
-
Massive SQL Server Database Moving Using Detach – Attach: The Complete Procedure
This is a complete configurable metascript, prepared to create detach statements, file move statement and re-attach statements for every database in your instance. You have only to configure the final destination for datafiles and the database list you want to migrate. The final generated script for every database selected will be something like this (remembar…
-
Massive Database Migration between SQL Server instances: the complete procedure v.2.0 *UPDATED*
(05/04/2014) Procedure Upgrades : – Added compresson to reduce bandwith,space necessary and transfer time – Reduced stat value for very large database – Added backup type parameter to choose from FULL,FULL_COPYONLY or DIFFERENTIAL backup (for bigger database migration) – Added Maxtransfersize and Buffercount parameters to improve backup performance (warning – this needs more memory!) –…