Monthly Archives: February 2012

SQLCMD 101

Posted on February 29, 2012 by

This evening, I was trying to build a script to configure database mirroring using SQLCMD. As I was not well-versed with sqlcmd, I started to search for a tutorial. A search on Bing, landed me on this page, which has … Continue reading →

Posted in How To, Just Learned, SQL Server, SQLCMD | Tagged , , , | Leave a comment

Shrinking Transaction log

Posted on February 6, 2012 by

Some days back, I had a discussion with one of my colleague about Shrinking a database log file. He told me that they had a database with a log size 10 times larger than the data file size, and they … Continue reading →

Posted in Backup - Restore, SQL Server, T-Log | Tagged , | 2 Comments

Configuring a Server Core Machine

Posted on February 2, 2012 by

Since last few days, I was planning to set up a new VM to run SQL Server 2012 RC0 on a server core machine. As SQL Server 2012 RC0 can be installed on a Server Core machine, I build a … Continue reading →

Posted in Deployment, How To, Just Learned, SQL Server, SQL Server Denali CTP1, TestLab | Tagged , , | 1 Comment