Hello. I am not sure if this is possible or if I am even asking it correctly. I will give it a shot.
I have a central SMS server with SQL 2005 and 4 child primary SMS servers with SQL 2005. Administrators on the child primary SMS servers manually delete resources from the database on their server. These deletions do not migrated up to the central SMS server. This means that reports created on the central server are not accurate.
Is there anyway I can compare central server with the child server and delete resources on the central server that are not present on the child servers?
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…