msdbdata.mdf missing after installing an instance of MSDE

Hi all,
msdbdata.mdf is missing after I install an instance of MSDE.
What could be causing this?
Thanks
hi Jason,
Jason Fischer wrote:
> Hi all,
> msdbdata.mdf is missing after I install an instance of MSDE.
> What could be causing this?
are you sure you correctly installed MSDE? no error has been reported? the
verbose log file shows no problems?
msdb database is a system database and is part of a proper installation...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Yes, there was no error reported while installing.
I know that msdb is a system DB, that's what is bugging me.
I will check the log file again and see if there is anything funny reported
even though an error isn't logged.
Thanks,
Jason
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3kkk2oFuh3b0U1@.individual.net...
> hi Jason,
> Jason Fischer wrote:
> are you sure you correctly installed MSDE? no error has been reported? the
> verbose log file shows no problems?
> msdb database is a system database and is part of a proper installation...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

msdbdata.mdf file is over 5 GB, cannot shrink it

I have problem with my sql server developer edition.

I began reciving alerts regarding disk space, and found out that the msdb files are 5 GB!!! the data file is full, so I cannot shrink it, but the table usage shows only a few MB used by tables.

its not advisable to shrink the system dbs except tempdb,but in your case just check if any user tables are created in msdb if so just delete the same to free diskspace.... then try shrinking msdb but b4 shrinking ensure you have the latest backup of all the dbs....
|||

There are no user tables on this server.

It a local developer version, I use for development and small checks, there is no back up nither.