Shrink Transaction Logs in all every database SQL Server

SQL Server transaction logs need backed up regularly, or they will grow and grow forever, eventually filling up all available disk space. That is best done in a maintenance plan. Unfortunately you have to remember to set that up post install, it doesn’t happen out of the box by default (why doesn’t it? Surely it […]

Read More Shrink Transaction Logs in all every database SQL Server
November 29, 2013

Remote Desktop Connection Manager

Remote Desktop Connection Manager, a free download from http://www.microsoft.com/en-gb/download/details.aspx?id=21101, lets you switch quickly between windows servers, saves the servers and your login details in a list.

Read More Remote Desktop Connection Manager
November 22, 2013

Flashback query alternative to point in time recovery

If data has been removed due to user error, it can be easily and quickly be brought back without the need for restores, using flashback query: CREATE TABLE temp_rescue AS SELECT * FROM owner.table AS OF TIMESTAMP TO_TIMESTAMP ( ‘Thu 14-Nov-2013 13:00:00’ , ‘Dy DD-Mon-YYYY HH24:MI:SS’ ) ; Or if the entire table has been […]

Read More Flashback query alternative to point in time recovery
November 18, 2013

sda: sense key Recovered Error linux fsck forcefsck

Errors in /var/log/messages: kernel: Current sda: sense key Recovered Error kernel: Additional sense: Failure prediction threshold exceeded kernel: EXT3-fs error (device sda9) in ext3_setattr: Journal has aborted kernel: EXT3-fs error (device sda9) in start_transaction: Journal has aborted Fix with (requires reboot + can be slow): fsck.ext3 -f -y /dev/sda9 To identify that name /dev/sda9 I […]

Read More sda: sense key Recovered Error linux fsck forcefsck
November 18, 2013

RMAN point in time restore

Rman point in time restore: rman connect target / connect catalog user/password@catalog_database run { shutdown immediate ! now take an OS copy of current control file and current online redo logs in case need to regress startup mount set until time “to_date(‘Mon 04-Nov-2013 09:00:00′,’Dy DD-Mon-YYYY HH24:MI:SS’)” ; restore database preview ; — optional, to check […]

Read More RMAN point in time restore
November 6, 2013