I ran into this exact problem with a SQL Server 2000 database, where the emergency
mode is an undocumented technique that should only be used while working
with Product Support Services (PSS) technicians. I was able to get all of the client??™s data
exported, but the client had no build script of the structure of the database. Tables were
filled with data, but indexes, triggers, and stored procedures were still missing. If the
client had created a structure backup at some point in the past, we could have returned
the database to a functional state within a reasonable amount of time. Instead, what
should have taken eight hours took four days.
Cold Backup
I??™ve run into situations where the DBA performs a cold backup only??”that is, he stops
SQL Server, backs up all of the data files, and then restarts the SQL service. The obvious
problem is that the technique makes the database unavailable while the backup is occurring.
Unless you have a large window for backup operations, this may not be an option.
Full-Text Backup
In SQL Server 2000, full-text catalogues were not included in any backup unless the
appropriate directories were backed up with the Microsoft Search service turned off.
Pages:
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113