Tag: database
Browse the blog by topic.
3 posts · All tags
-
MSSQL Emergency Mode
There are a few undocumented things about the MSSQL Server 2000 missing in the knowledgebase of Microsoft. That's a way to get a database marked as suspect into emergency mode: use[master] go execute sp_configure 'all...
-
MS-SQL Recovery
There are two kinds of customers: The ones who do backups and those who didn't have data loss yet, ignoring all good advice and best practices. However, in the end it's always us, the IT crowd being yelled for to look...
-
Who's connected to my MSSQL server?
Today I was trying to restore a backup of our MSSQL server when a user decided to drive me crazy by not disconnecting after telling anyone that we need to do that restore. So I fired up the management studio and had a...