Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Add Prevalidation message: the “SQL Server VSS Writer” service set to disabled on Source SQL server

Add Prevalidation message: the “SQL Server VSS Writer” service set to disabled on Source SQL server

I have had recently the case where a huge SQL server had the “SQL Server VSS Writer” service not running because it was disabled...

This resulted in the Block Monitoring driver not being aware of the changes happening on the Source since the initial full replication completed.

After the cutover completed, the customer realized too late that one week of SQL data was missing on Target...and users were already performing some change on the database Target.

Now they need to choose between rolling back the workload and lose the data that has been changed since Cutover completed, or do not roll back the server and miss one week of data...HUGE BUSINESS IMPACT!

This could have been avoided by adding a pre-validation mechanism that would detect that the server is running SQL and that the SQL VSS writer was disabled (I could see everything in the diagnostic logs, so PlateSpin was aware of these).

1 Comment
Micro Focus Contributor
Micro Focus Contributor
Status changed to: Under Consideration
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.