Monthly Archives: November 2012

Contained Database 101

Although it looks like an individual entity, a database in SQL Server is tightly integrated with the SQL Server instance. Every time we move an user database from one instance to another, a series of steps follow, which includes transfers … Continue reading

Posted in ContainedDB, How To, SQL Server, SQL2012, UG Meet | Tagged , , , , , | 5 Comments

Why my Differential Backup was Failing?

In one of the online SQL forum, a forum user reported that, one of their server is scheduled for a weekly full database backup & daily differential database backup. However, during mid of this week, the daily differential job failed … Continue reading

Posted in Backup - Restore, Jobs, SQL Server | Tagged , , | Leave a comment

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