Hyperbac Control Service locks files - Sharing Violation.

Silent compression for faster, smaller SQL Server backups

Moderators: eddie davis, Colin Millerchip, fionag

Hyperbac Control Service locks files - Sharing Violation.

Postby RML51 » Thu Mar 29, 2012 2:23 pm

I just downloaded and installed a new trial copy of HyperbacComponents.zip onto a test server instance. I ran a Virtual Restore yesterday and that successfully completed. Overnight I had a job scheduled to RoboCopy new .SQB files from my production server to the test server where HyperBac and VR are installed. The RoboCopy is setup to overlay the existing .SQB files. The RoboCopy did not work because the HyperBac Control Service had the old .SQB files locked which produced a file Sharing Violation.

The RoboCopy error looks like this: \\\\MYTESTSRV\\D$\\MSSQL.1\\MSSQL\\Backup\\TestFile_Backup_Encrypted_1.sqb Sharing violation. Process Exit Code 4. The step failed.

Both servers are SQL 2005 SP4. The OS is Windows Server 2008.
RML51
 
Posts: 16
Joined: Mon Oct 31, 2005 2:57 pm

Postby Matthew Flatt » Thu Mar 29, 2012 3:00 pm

Hi RML51,

When a database has been virtually restored, the HyperBac service will lock the associated backup file to prevent that file being removed/changed thus breaking the Virtual Restore database which relies on it.

If the plan is to refresh the Virtual Database each night from a backup taken on production, I would drop the Virtual Restore database before the nightly backup file copy/new Virtual Restore takes place.

I hope that helps,
Matthew Flatt
Test Engineer, HyperBac
Matthew Flatt
 
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm

Postby RML51 » Thu Mar 29, 2012 3:33 pm

Thanks, I'll give that a try.
RML51
 
Posts: 16
Joined: Mon Oct 31, 2005 2:57 pm


Return to SQL HyperBac 5

Who is online

Users browsing this forum: No registered users and 0 guests