I don't have a running packages folder..

in object explorer I have databases, security, server objects, replication, management, and notification services

DBCC CHECKDB does not report any errors. Did some more digging and I suspect that the errors may have been caused by intermittent SAN problems that we HAD been...

It happens periodically.. not often, maybe once every two weeks.

when restoring Master, I usually stop SQL Server and then start it from a command prompt

from command prompt, navigate to the directory where the sql server executeable resides and start...

in case anyone is interested.. figured it out last night:

sp_helpsubscription @publication = 'MY publication'

Did NOT see my new Article (new table(s)

sp_addsubscription @publication = 'MY...

When I do:

sp_helpsubscription @publication = 'my publication'

I do not see my two new tables as articles

read somewhere I need to do this:

-- sp_addsubscription 'my publication' , 'my new article' ,...

yes. they are small. When I kick off a snapshot I get this:

'a snapshot was not generated because no subscriptions needed initialization' ??

I see another discrepency. for each table that is replicated, there are three stored procedures on the subscriber:

sp_MSins_MyTable

sp_MSupd_MyTable

sp_MSdel_MyTable

and these 3 stored procedures do not exist on...

Thank you everyone!! This was my first time dealing with corrupted databases caused by hardware problems and your support was MUCH appreciated~!!!!

Ended up restoreing two databases on one...

ONce they FINALLY fixed the SAN problems, I ran DBCC DBCHECK on the databases again and it repaired some but not all of the consistency errors. At...

RTM is just Release To Maintenace... sql server with NO service Packs applied

Thanks Steve (and everyone)

good to know both ways:

restore HeaderOnly

from disk = 'X:\MSSQL\backup\msdb_db_200804061122.BAK'

and the sqlservr.exe properties

the later wouldn't have helped me since we lost the Server.. but...

Thank you so much. my build is 760.. SP3 : (

Can I UNINSTALL SP4 or do I HAVE to reinstall???????????

Thanks Gail!

We do have backups but our servers guys control them.. they are to tape... tracking them down now.. best to drop the DBs before restore??? ...