Monthly Archives: March 2009

login failures for windows based authentication what does that error mean

Have you ever come across the following login failure within the SQL Server error logs? “Login failed for user ”. (Note the empty user name). This is all a bit unusual if you think about it. Since the user attempting … Continue reading

Posted in Security, SQL

auto generating statements every dba should try one

Have you ever performed a scripted restore or some of similar operation and then got entirely frustrated at the laborious and error prone nature of this exercise especially when the database consists of many datafiles and transaction log files? Of … Continue reading

Posted in Automation, Backup and Recovery, Database, T-SQL

Moving SQL Server Data and Log files, dont detach

Recently I came across the ALTER FILE part of the ALTER DATABASE command and started thinking about its use when moving physical datafiles. I must admit that this particular part of the ALTER DATABASE command has largely gone unused. Whilst … Continue reading

Posted in Backup and Recovery, Database, File-System