def start_sql_server(self):
""" Start the SQL Server instance after the backup is completed """
with winutils.DisableFileSystemRedirection():
cmd = 'net start "SQL Server ({0})"'.format(
self.sql_server_instance)
(out, err) = utils.create_subprocess(cmd)
if err != '':
raise Exception('Error while starting SQL Server'
', error {0}'.format(err))
LOG.info('SQL Server back to normal')
def stop_sql_server(self):
""" Stop a SQL Server instance to
perform the backup of the db files """
LOG.info('Stopping SQL Server for backup')
with winutils.DisableFileSystemRedirection():
cmd = 'net stop "SQL Server ({0})"'\
.format(self.sql_server_instance)
(out, err) = utils.create_subprocess(cmd)
if err != '':
raise Exception('Error while stopping SQL Server,'
', error {0}'.format(err))
def vss_delete_shadow_copy(shadow_id, windows_volume):
"""
Delete a shadow copy from the volume with the given shadow_id
:param shadow_id: XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
:return: bool
"""
with winutils.DisableFileSystemRedirection():
cmd = ['vssadmin', 'delete', 'shadows',
'/shadow={0}'.format(shadow_id), '/quiet']
(out, err) = utils.create_subprocess(cmd)
if err != '':
raise Exception('Error deleting shadow copy with id {0}'
', error {1}' .format(shadow_id, err))
vss_delete_symlink(windows_volume)
LOG.info('Deleting shadow copy {0}'.format(shadow_id))
return True
def vss_create_shadow_copy(windows_volume):
"""
Create a new shadow copy for the specified volume
Windows registry path for vssadmin:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\VSS\Settings
MaxShadowCopies
Windows is limited in how many shadow copies can create per volume.
The default amount of shadow copies is 64, the minimum is 1 and the maxi-
mum is 512, if you want to change the default value you need to add/edit
the key MaxShadowCopies and set the amount of shadow copies per volume.
MinDiffAreaFileSize
The minimum size of the shadow copy storage area is a per-computer setting
that can be specified by using the MinDiffAreaFileSize registry value.
If the MinDiffAreaFileSize registry value is not set, the minimum size of
the shadow copy storage area is 32 MB for volumes that are smaller than
500 MB and 320 MB for volumes that are larger than 500 MB.
If you have not set a maximum size, there is no limit to the amount
of space that can be used.
If the MinDiffAreaFileSize registry value does not exist, the backup
application can create it under the following registry key:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\VolSnap
Freezer create a shadow copy for each time the client runs it's been
removed after the backup is complete.
:param volume: The letter of the windows volume e.g. c:\\
:return: shadow_id: XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
:return: shadow_path: shadow copy path
"""
shadow_path = None
shadow_id = None
vss_delete_symlink(windows_volume)
with winutils.DisableFileSystemRedirection():
path = os.path.dirname(os.path.abspath(__file__))
script = '{0}\\scripts\\vss.ps1'.format(path)
(out, err) = utils.create_subprocess([
'powershell.exe', '-executionpolicy', 'unrestricted', '-command',
script, '-volume', windows_volume
])
if err != '':
raise Exception('[*] Error creating a new shadow copy on {0}'
', error {1}'.format(windows_volume, err))
for line in out.split('\n'):
if 'symbolic' in line:
shadow_path = line.split('>>')[1].strip()
if '__RELPATH' in line:
shadow_id = line.split('=')[1].strip().lower() + '}'
shadow_id = shadow_id[1:]
logging.info('[*] Created shadow copy {0}'.format(shadow_id))
return shadow_path, shadow_id