Hardware Failure, Help w/recover of the msdb database

We lost the hard drive on a dev server. All the databases where backed up
with the exception of Master, Model, and MSDB. I was able to recover the
msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
Is it possible to recover the DTS packages from these files? or am I hosed?
Any help would be greatly appreciated.
Thanks
Kevin
You should be able to attach the old MSDB back to the server.
http://www.databasejournal.com/featu...le.php/3379901
http://www.support.microsoft.com/?id=224071
Andrew J. Kelly SQL MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:0C69CE35-574E-49D5-810E-06854EE51460@.microsoft.com...
> We lost the hard drive on a dev server. All the databases where backed up
> with the exception of Master, Model, and MSDB. I was able to recover the
> msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
> Is it possible to recover the DTS packages from these files? or am I
> hosed?
> Any help would be greatly appreciated.
> Thanks
> Kevin

Hardware Failure, Help w/recover of the msdb database

We lost the hard drive on a dev server. All the databases where backed up
with the exception of Master, Model, and MSDB. I was able to recover the
msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
Is it possible to recover the DTS packages from these files? or am I hosed?
Any help would be greatly appreciated.
Thanks
KevinYou should be able to attach the old MSDB back to the server.
http://www.databasejournal.com/features/mssql/article.php/3379901
http://www.support.microsoft.com/?id=224071
--
Andrew J. Kelly SQL MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:0C69CE35-574E-49D5-810E-06854EE51460@.microsoft.com...
> We lost the hard drive on a dev server. All the databases where backed up
> with the exception of Master, Model, and MSDB. I was able to recover the
> msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
> Is it possible to recover the DTS packages from these files? or am I
> hosed?
> Any help would be greatly appreciated.
> Thanks
> Kevin

Hardware Failure, Help w/recover of the msdb database

We lost the hard drive on a dev server. All the databases where backed up
with the exception of Master, Model, and MSDB. I was able to recover the
msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
Is it possible to recover the DTS packages from these files? or am I hosed?
Any help would be greatly appreciated.
Thanks
KevinYou should be able to attach the old MSDB back to the server.
http://www.databasejournal.com/feat...cle.php/3379901
http://www.support.microsoft.com/?id=224071
Andrew J. Kelly SQL MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:0C69CE35-574E-49D5-810E-06854EE51460@.microsoft.com...
> We lost the hard drive on a dev server. All the databases where backed up
> with the exception of Master, Model, and MSDB. I was able to recover the
> msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
> Is it possible to recover the DTS packages from these files? or am I
> hosed?
> Any help would be greatly appreciated.
> Thanks
> Kevin

Hard time master log files

Hi,
I have a small DB, about 200MB, but my transaction log files grows regulary
over 900MB.
The only way I have been able to manage the log file is to detach the
database, delete the log file and reattach the DB.
Is there any better way to manage growing log files?
Thanks in advance
ChristianHi,
Check the recovery model for your database using the below command:-
Select DATABASEPROPERTYEX(<dbname>,Recovery )
If the recovery is Simple then the LDF should grow big intil u have some
batch operation. In that once the trasnaction is over you could
shrink the LDF file using DBCC SHRINKFILE command
If the recovery model is either FULL or BULK_LOGGED then you need to do the
Transaction log backup using BACKUP LOG command. This
will keep the LDF file not to grow.
Thanks
Hari
SQL Server MVP
"Christian Perthen" <abracadabara@.dontreplytothidress.com> wrote in
message news:e2YgKk8QFHA.3928@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have a small DB, about 200MB, but my transaction log files grows
> regulary
> over 900MB.
> The only way I have been able to manage the log file is to detach the
> database, delete the log file and reattach the DB.
> Is there any better way to manage growing log files?
> Thanks in advance
> Christian
>

Hard Drive Crashed. master & user db mdf & ldf files lost

Hello.

One of our hard drives has crashed and as a result we have lost our master mdf/ldf & user db mdf/ldf files. It's not that a critical system by any means, but if the hard drive crashes and the master mdf/ldf files & user db mdf/ldf are lost, is there any way of restoring the system?

I'm thinking we probably need to re-install Enterprise Manager completely, and re-install the user db from a backup.

Any advice/suggestions would be much appreciated.

Thanks in advance,If the disks are toast, then you have to restore from your backups. When you have the hardware and O/S back to where they need to be, install SQL Server with any required service packs/patches, then restore the master database (see BOL for instructions), then restore the user databases.