Windows

Create Windows Server 2012 R2 Failover Cluster on Hyper-V

In this post I will write step by step guide how to create Windows Server 2012 R2 fail-over cluster. I’ve simulated this fail-over clustered on lab/test environment using Hyper-V on my Windows 10 laptop. I already Have 3 windows server Virtual Machine running, one will server will be a Domain Controller and also will hosting shared storage… Continue reading Create Windows Server 2012 R2 Failover Cluster on Hyper-V

Windows

Prepare iSCSI Target Server to Host Failover Cluster Shared Storage

In this post I’m going to show my self or the others that read this post about how to configure a Windows Server 2012 R2 to act as iSCSI target. I was prepare 3 Virtual Machine running Windows Server 2012 R2, one as Domain Controller and the others two will be 2 nodes failover cluster. I… Continue reading Prepare iSCSI Target Server to Host Failover Cluster Shared Storage

Backup & Restore

Find out logical file name of a database backup file

It’s easy when you want to restore an SQL Server database backup file using SQL Server Management Studio (SSMS). Since you only have to know where you’ve stored backup file and with few click and done, database will successfully restored. But what if you wanna use T-SQL instead to restore the database and you don’t want… Continue reading Find out logical file name of a database backup file

SQL Server Tips

Rebuild SQL Server system database

Recently one of our customer database server becoming very noisy and without my knowledge, they restarted that server. After restart, that server wasn’t noisy again but they having trouble cannot login to the application. I’ve found out that SQL Server service won’t started and found the following error in event viewer : The SQL Server (MSSQLSERVER) service… Continue reading Rebuild SQL Server system database

Backup & Restore

Using fn_dblog, fn_dump_dblog and restoring with STOPBEFOREMARK

I’ve found this very useful article wrote by Paul Randal and decide to rewrite it on my own blog.  You can find full and the original article in this link. Someone dropped a table and you want to find out when it happened and maybe who did it. The default trace has also wrapped so you… Continue reading Using fn_dblog, fn_dump_dblog and restoring with STOPBEFOREMARK

Backup & Restore

Exclusive access could not be obtained because the database is in use

I’ve got an email from a friend. He was made backup of a database, and restore that backup file to another new database but he got error “Exclusive access could not be obtained because the database is in use”. I’m trying by myself to restore a database in my machine with the same scenario and got the full… Continue reading Exclusive access could not be obtained because the database is in use