Red Gate forums :: View topic - Hyperbac Control Service locks files - Sharing Violation.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL HyperBac 5
SQL HyperBac 5 forum

Hyperbac Control Service locks files - Sharing Violation.

Search in SQL HyperBac 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
RML51



Joined: 31 Oct 2005
Posts: 16

PostPosted: Thu Mar 29, 2012 2:23 pm    Post subject: Hyperbac Control Service locks files - Sharing Violation. Reply with quote

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.
Back to top
View user's profile Send private message
Matthew Flatt



Joined: 15 Jan 2008
Posts: 253

PostPosted: Thu Mar 29, 2012 3:00 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
RML51



Joined: 31 Oct 2005
Posts: 16

PostPosted: Thu Mar 29, 2012 3:33 pm    Post subject: Reply with quote

Thanks, I'll give that a try.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group