Category Archives: SQLCMD

Unable to start SQL Server after relocating TempDB

After I modified the file size of tempdb database yesterday on my SQL Express instance, SQL Server was failed to start. When I checked the SQL Server error log, following entries were recorded. 2012-11-07 11:25:34.99 spid10s Error: 17053, Severity: 16, … Continue reading

Posted in SQL Server Configuration, SQL Server, How To, Just Learned, SQLCMD | Tagged , , , | 7 Comments

Rebuild MSDB Database

I had accidentally deleted the transaction log file of msdb database on a newly installed SQL Server 2008 R2 instance yesterday, while I was removing the old tempdb files. Although I normally copy the system database files prior removing the … Continue reading

Posted in Disaster Recovery, Backup - Restore, SQL Server, How To, Just Learned, SQLCMD | Tagged , , , , , | 2 Comments

Database Mirroring with SQLCMD

Finally, I build my script to configure Database Mirroring in High Safety Mode. Earlier, I had written a post on configuring Database Mirroring in High Availability Mode. However, this time, I had written a script to automate the complete process … Continue reading

Posted in Database Mirroring, Automation in SQL Server, SQL Server, How To, Just Learned, SQLCMD, T-SQL | Tagged , , , | 2 Comments


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 SQL Server, How To, Just Learned, SQLCMD | Tagged , , , | Leave a comment