Building proof of concepts is harder than it looks. John Sterrett shows how DBAs and developers can build them faster and get more out of Windows Azure.
SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run
After a backup restore mistake, SQL Server would not start and ERRORLOG said the database ‘model’ is marked RESTORING. This is how I got it running again.
SQL SERVER – FIX: ERROR : Msg 3136, Level 16, State 1 – This differential backup cannot be restored because the database has not been restored to the correct earlier state
Msg 3136 says the differential backup cannot be restored because the database was not restored to the correct earlier state. I explain why it happens.
SQL SERVER – FIX: ERROR : Msg 3023, Level 16, State 2 – Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized
Backup jobs failing with Msg 3023? Backup, file changes and encryption changes on a database must be serialized. I look at what caused it for one reader.
SQL SERVER – Unable to Restore From Backup After Detach Operation
A young guy came to me and said – “I found a bug in SQL Server Restore”. How to fix Unable to Restore From Backup After Detach Operation.
SQL SERVER – Why my Database is in Restoring Mode After Taking Backup?
Pepper, a SharePoint consultant, asked why her database is in restoring mode after taking a backup. Here is the story and the answer.
Database Maintenance Checklist: Daily, Weekly and Monthly
A database maintenance checklist keeps the dull checks from slipping. This post lists what to check daily, weekly and monthly in SQL Server, with one small read-only query for backups, errors, free space, CHECKDB, statistics, growth, logins and patch level.