Tuesday, August 27, 2013

The application is unable to start correctly 0xc0000005 after windows update >> Uninstall Microsoft Update

I don't know how this Windows Update got by Microsoft QA but be warned - it has caused issue on 2 of our Windows 2008 R2 Enterprise servers.

I had to uninstall the KB and reboot.
FYI: I didn't do the strikeout steps, and both reboot times were normal and not long

the application is unable to start correctly 0xc0000005 after windows update

1. Disconnect from the internet  
2. Open Control Panel
3. Open Program & Features
4. Click "View installed updates" on the left-hand side
5. Find "Security update for Microsoft Windows (KB2859537)" under the Microsoft Windows section
6. Uninstall that update and restart you PC (may take a very-VERY long time to configure)
7. Go to Windows Updates and hide  (KB2859537)
8. Reconnect to the internet
9. Fix your System Restore feature; You might have to remove a fake C: drive and enable System Restore on the correct Windows drive.

Monday, April 1, 2013

Use [Ctrl+Alt+End] in RDP session to change the password, instead of [Ctrl+Alt+Del]

Use [Ctrl+Alt+End] in RDP session to change the password, instead of [Ctrl+Alt+Del]

Thursday, March 8, 2012

Email SQL Job Notification to Multiple Recipients

It's actually quite simply if you tried it

1. Create a New Operator
SQL Server Agent -> Operators -> right-click -> New Operator

2. Choose a Name (e.g. "Group") and enter multiple emails in the E-mail name: field, separated by ;
a@gmail.com; b@gmail.com

3. In your SQL Job Notification, select "Group" as Operator and that's it


Monday, January 23, 2012

Restoring SYSTEM databases

I had the opportunity to restore a few system databases due to disk inconsistency/corruption. Actually my first time in a long time and was it fun. I have a few tips to share

All below were done on a SQL Server 2005 instance

Restoring MASTER Database!!
- start SQL Server in Single User mode (add -m to the startup parameter)
- You can Google this with lots of results. Microsoft How to on SQL 2008 R2

Restoring MSDB Database
- This is easy, just restore like a user database

Restoring MODEL Database!
- Restore model in RECOVERY mode, never in NORECOVERY mode as SQL Server will stop (due to tempdb unable to create, without a model database)
- If you did NORECOVERY, the only way to get in is manual work.
For me, I started it and detach-and-attach the model database that I copy from another location, as one cannot issue RESTORE command in Single-User mode

net start MSSQLSERVER /c /m /T3608 (you can go into SQL BINN and run sqlserver -c -m -T3608 as well)

sqlcmd -E (to connect to the SQL Server)

Detach and Re-attach model database
sp_detach_db 'model'
sp_attach_db 'model', 'DATA.mdf', 'LOG.ldf'
use model

Command line parameterUse
-cForces an instance of SQL Server not to start as a service.
-mAllows updates to the system catalog.
-T3608Recovers the master database only.

Wednesday, July 13, 2011

There is a ($50 USD) benefit to Read and Comment Simple Talk articles!

Today is my lucky day as I unexpectedly found a $50 USD Amazon.com gift card in my email inbox, courtesy of simple-talk, all because I read and commented on Tony's "Cloud Backup: Getting the Users' Backs Up" article

You can subscribe to Simple-Talk's SQL and RSS, and usually each newsletter will end with this comment
Reply to my blog post to be in with the chance of winning a $50 Amazon voucher.

I just love Red Gate more and more (as Simple-Talk is owned by Red Gate)