Posts From November, 2009

Create Insert 

Posted by Philip Leitch Tuesday, November 10, 2009 2:40:42 AM Categories: Database Administration Procedure

Creates an easy "Insert" script for transfering data, dynamically constructed based on the table:

e.g. Insert into '[XYZ] Values('test', 2,2,'Value')

... read more
 

Remove Backup History 

Posted by Philip Leitch Monday, November 9, 2009 6:11:50 PM Categories: Database Administration

Remove Backup History which will reduce the size of MSDB and also increase the speed of backup and restore routines.

... read more
 
Copyright 2009 Philip Leitch