Geeks With Blogs
BI cooking with a touch of SQL January 2013 Entries
Change the Maxsize and Filegrowth of a datafile and a logfile
If you need to alter a database file and logfile to change their maxsize and filegrowth settings, here is a small script that might help you ---------------------------... spChangeMaxsizeandFilegrowt... Author: Remko de Boer-- Created: 2013-01-30-- Description: Change the Maxsize and filegrowth of database with a single-- datafile and a single transaction ......

Posted On Wednesday, January 30, 2013 12:09 PM

Grouped Failover, a 2008R2 version of Availability groups
One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover. Instead of configuring it in SQL mirroring, you have to administrate the connected databases yourself and with a single stored procedure you will be able to failover a group of databases. It also gives you the option to ......

Posted On Wednesday, January 16, 2013 11:31 PM

Force shrink of transaction log after a full backup
After installing vCenter and connecting it to a SQL Server 2008R2 database server and making it high available with the help of database mirroring, somthing anoying started to take place. After a full backup the transaction log does NOT get 'truncated' and shrunk. So within a day or 5 my transaction log drive was full and vCenter refused to operate. After a bit of research it turns out that vCenter keeps an open transaction to the tailend of the transaction. Even during a full backup. So this open ......

Posted On Wednesday, January 16, 2013 3:07 PM

Copyright © remko | Powered by: