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 How To, Just Learned, SQL Server, SQL Server Configuration, 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 Backup - Restore, Disaster Recovery, How To, Just Learned, SQL Server, 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 Automation in SQL Server, Database Mirroring, How To, Just Learned, SQL Server, SQLCMD, T-SQL | Tagged , , , | 2 Comments

SQLCMD 101


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