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

SQL Server Tips

How to move SQL Server transaction log files to different location

One of our customer recently purchase new hard disk for their database server, and need to place all SQL Server transaction log files to that new hard disk. As far as i know, SQL Server transaction log file records every transaction that was executed in a database. And i think to placing transaction log files in separated location will… Continue reading How to move SQL Server transaction log files to different location