Whenever I try to start the SQL2000 sevice, I get the error "table tempdb in bypass recovery mode" and the process is terminated... It started when we first received the message that the transaction log for the 'tempdb' database was full although it was set to grow and ample space was availiable (2GB). We created a second log and this message appeared... HELP!!!
You apply a trace flag when you start sql server--if you look at the service property, you can add /t startup option--see the options below....It's weird that it recreated tempdb and then gave a recovery
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…