-
编辑 删除
Pop Rivett and the Suspect Database
Blake Savage gazed in horror at the string of errors in the database activity log of his communications module. It was always at the worst possible moment that SQL Server grenaded itself and produced a corrupt database. Without the database data, all off-planet communications were impossible! How were they to get back to their ship?[@more@]The front of his state-of-the-art 'Goldfish' helmet began to steam up, as panic set in. "Captain", shouted Blake over his futuristic intercom,
-
编辑 删除
Disaster Plan
Check database and log file of (Master, HowdyDatabase, Btell, BlackPebble, OCE), to use sp_attach_db. - sp_attach_single_file_db, to find out the last checkpoint. If cann’t, go to next step[@more@] If there is no .ldf, create a same name database, then stop sql server, use the .mdf file to cover the name database file, then rebuild log file, set emergency mode (sysdatabases status = 32768), but need to remember the original sysdatabases status va
