SQL Server Integration Services (SSIS) can also save packages to the MSDB database.
Be sure you??™re clear on whether packages are saved to MSDB or on the file system. Integration
Services development is now presented as a Visual Studio 2005 project, so there
may be a disconnect between you (the DBA) and someone creating that project.
CHAPTER 3 n RESTORING A DATABASE 66
Another impact of overwriting the MSDB database is that all job history information
is lost. Many may not be concerned with this, but I find that the more historical information
(and job history, in particular) I have on the operation of my system, the better
prepared I am to address issues or plan for future needs.
First, you must stop SQL Agent. Once you stop it, you can restore it like any other
database:
RESTORE DATABASE MSDB
FROM FILE=C:\msdb.bak
WITH RECOVERY
MSDB runs in Simple Recovery mode, so this will always be an easy restore from a
full backup. Note how I continue to explicitly type in the WITH RECOVERY option, even
though it??™s the default. If it??™s starting to annoy you, good??”you??™ve learned that specifying
it explicitly is important.
Pages:
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160