First off, do you have a backup of the reporting database from before the hack? A restore to another server or under a different name would allow you to check...

Any chances this is a SQL Native login, not a domain login? Odds are it's SQL Native and the SIDS don't match between the nodes in the AoHA cluster. Every...

What's the relevance of the nightly full backup with regards to Log Shipping, and why do you want to take a second full backup? Are you only applying logs once...

Personal recommendation based on experience... I would keep the databases on the same instance. Some of the reasons, in no particular order being:

1. If you are doing any cross instance...

Sorry, there is currently no feature in MS SQL Server that exactly correlates with Oracle RAC. Oracle RAC uses a shared memory system that allows them to do all CRUD...

I'm really interested in this:

And let me know if those 3rd party apps are using GUIDs for PKs/Clustering Keys... I know how to fix those so that fragmentation...

Thanks Jeff for your great response, there's a lot of good material in that. Being in the...

Despite all the warnings about talking to your licensing re-seller, and my own caveat that any advice I give must be checked with Microsoft, etc. the following is what I...

Looks like the "Dump on errors" option has been enabled in the Execute Package Dialog box. 

check out the link:Generating Dump Files for Package Execution

Found...

As long as the formatting in the source table is consistent, i.e. always %%S, %%X, %%P, then it comes down to basic substrings. It doesn't matter if any given portion...

Keeping this relatively "simple" and avoiding technical terms, deduplication by applications like CommVault rely largely on the assumption that any two successive versions of a given file have changed minimally,...