After a fresh install of my SQL 7 server (production), I was able to bring back my databases (thru single user mode w/ the master, model, & msdb) from the backups that I've made. BUT, rt b4 i brought those databases backup I've tried to recreate a mySouthWind db and then restore it from the backup. It worked, but all my users/roles were not there! So then I went to the method of rebuilding/restoring the master, model, msdb in single user mode --- which actually restores everything! Perfect rt? Well, every databases are exactly as they were EXCEPT for that mySouthWind db (which somehow gave me a 'suspect' notice.) Anyways, I've restarted the database and mySouthWind db seems to be working fine; The only problem left is that mySouthWind db is missing the (syspublications, syspublications, sysarticles tables). When I checked the backup locations for the databases, all *.mdf and *.ldf are backuped accordingly to the right destination, except for mySouthWind db which has its mySouthWind.mdf file correctly w/ the other *.mdf BUT the mySouthWind.ldf file is scituated in another location.
So I'm here stumbling on what's the best way of putting things back as they were. In this case, how do fill in the missing tables??
So I'm here stumbling on what's the best way of putting things back as they were. In this case, how do fill in the missing tables??