Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
Contact the author
for this blog
Hemantgiri S. Goswami is working as a Consultant at Surat, INDIA. He has been a Microsoft SQL Server MVP three years running; he also moderates multiple SQL Server community forums including http://www.sql-server-performance.com
. He actively participates and speaks at local user group events organized under the aegis of www.surat-user-group.org, DotNetChaps and CSI Surat chapters, of which he is a founding and active member. He regularly publishes article on his blog space http://www.sql-server-citation.com
. He has recently taken up a new initiative - blogging about SQL in his native language Gujarat through his blog http://sqlservercitation-gujarati.blogspot.com
. He is an Author of the book SQL Server 2008 High Availability.
- Posted on 27 October 2011
Couple of week back Megha Sharma send me an email with a document attached, this document is all about how to refresh QA database with manual script. Here is the preview of the document, and the reason why we should follow the method in her own words:
QA environment frequently needs Database refresh and hence
space on its disks. QA Database is refreshed from Production followed by a data
purge, which leaves a lot of free space in the database. In order to release
the free space, we follow database shrink command, a lengthy & single
thread I / O operation, also cause high data fragmentation.
Sounds interesting ? Want to download the complete document ? Download Link
Please post back your review in the comment section here.
To avoid this resource & time consuming activity, we do
a Refresh Database with manual scripts, in which, we create a new database,
transfer tables, data & other objects via scripts.
The Generate Scripts option of a database generates script
for the complete database and transfers data (using Insert into command, highly
logged), to avoid this we do a Select * into, to transfer table definition
& data (minimal logged & fast, being a bulk operation) & then
generate Table Objects (Keys, Constraints, Triggers, Indexes) via manual
scripts & other database objects (Views, Stored Procedures, Functions,
Users, Roles, Schemas) via generate scripts.
-- Hemantgiri S. Goswami (http://www.sql-server-citation.com )
Leave a comment on the original post
[feedproxy.google.com, opens in a new window]