MSDE - Master database

HI all,
What is supposed to be in te master database, and how can I fix it.
Seems to me that I messed up and have some tables, lviews, etc,looks like
from northwind database.
I think it happened when I tried the upsize wisard in access and made a big
booboo
Robert
Restore the Master database. You backed it up didn't you?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Robert Bravery" <me@.u.com> wrote in message
news:eXzllihtEHA.3860@.TK2MSFTNGP09.phx.gbl...
> HI all,
> What is supposed to be in te master database, and how can I fix it.
> Seems to me that I messed up and have some tables, lviews, etc,looks like
> from northwind database.
> I think it happened when I tried the upsize wisard in access and made a
> big
> booboo
> Robert
>
|||HI,
I am just testing at the moment, only installed mSDE a few days agao.
Is there no script somewhere that I can delete and recreate.
Being new to MSDE I have no idea of the purpose of this database
Thanks
Robert
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:e2P6xkktEHA.4044@.TK2MSFTNGP09.phx.gbl...
> Restore the Master database. You backed it up didn't you?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> __________________________________
> "Robert Bravery" <me@.u.com> wrote in message
> news:eXzllihtEHA.3860@.TK2MSFTNGP09.phx.gbl...
like
>
|||other option would be to rebuild the master database using the rebuildm
utiliy . This option is used if u do not have any backup of the master
database.
|||hi Girish,
"Girish Sundaram" <girishs@.microsoft.com> ha scritto nel messaggio
news:RgKxw65tEHA.2520@.cpmsftngxa10.phx.gbl
> other option would be to rebuild the master database using the
> rebuildm utiliy . This option is used if u do not have any backup of
> the master database.
unfortunately you do not have access to "rebuildm" utility in MSDE..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msdb recreate cause replication problems

We just went through a nasty experience whereby we had to recreate the
MSDB database.
System is now back, but replication is completely messed up. Is there a
way to get all the MS* tables back, in the MSDB? I tried to de-install
and install Replication, but that doesn't seem to generate all the
required tables and procs
SQL2005, SP1.
Any help much appreciated!
I take it you mean you want your jobs to pick up where they left off.
Dropping and recreating the publications and subscriptions should do that.
If you mean the replication table in msdb, they are created there when you
install sql server.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<renedevries@.gmail.com> wrote in message
news:1159994716.013545.158270@.i3g2000cwc.googlegro ups.com...
> We just went through a nasty experience whereby we had to recreate the
> MSDB database.
> System is now back, but replication is completely messed up. Is there a
> way to get all the MS* tables back, in the MSDB? I tried to de-install
> and install Replication, but that doesn't seem to generate all the
> required tables and procs
> SQL2005, SP1.
> Any help much appreciated!
>
|||Eventually called MS Tech Support. The goal was to het replication
working at all, never mind the jobs or the previous state. But since
all relevant tables in msdb where gone, the whole thing was in limbo
The only REAL option is indeed a fresh install of SQL. However, they
where able to help me out, though a number of steps which involved
removing repliation from the database, dropping the distribution db,
and some other assorted trickery. But eventually we got it to work.
Turns out that if you re-create the distribution database all the
associated msdb tables and jobs are also recreated. Fortunately ;)
Lesson: make sure you keep good, validated backups of msdb at all
times. Bitten once again
Rene
Hilary Cotter schreef:

> I take it you mean you want your jobs to pick up where they left off.
> Dropping and recreating the publications and subscriptions should do that.
> If you mean the replication table in msdb, they are created there when you
> install sql server.
> --