Uncategorized

ChunkSize Error in vCenter Server 6.5

OVF deployment fails with “OVF parameter chunkSize with value XXXXXXXXXX” error in vCenter Server 6.5

  • Deploying an OVF in vCenter Server 6.5 fails.

Screen Shot 2018-06-20 at 13.35.28

This issue occurs because the chunkSize OVF parameter is not supported in vCenter Server 6.5.
Resolution as per – https://kb.vmware.com/s/article/2148588
To resolve the issue, update the OVF template by removing the chunkSize parameter.

  1. For OVA templates, extract the individual files using a tar utility (For example: tar xvf). This should include the ovf file (*.ovf), manifest (*.mf), and virtual disk (*.vmdk).
  2. Combine virtual disk chunks into a single disk with this command:

    Linux or Mac:

    cat vmName-disk1.vmdk.* > vmName-disk1.vmdk

    On Windows:

    copy /b vmName-disk1.vmdk.000000 + vmName-disk1.vmdk.000001 + ….. + <until the last fragment> vmName-disk1.vmdk 

    Note: If there is only one virtual disk chunk fragment, it can be renamed to the destination disk. If there are multiple disks with chunk fragments, then each should be combined to the respective destination disks. For example: *disk1.vmdk, *disk2.vmdk.

  3. Remove the chunkSize attribute from the OVF descriptor (.ovf) using a plain text editor.

    For example:

    <File ovf:chunkSize=”7516192768″ ovf:href=”vmName-disk1.vmdk” ovf:id=”file1″ ovf:size=… />

    to:

    <File ovf:href=”vmName-disk1.vmdk” ovf:id=”file1″ ovf:size=… />

  4. Deploy OVF Template from the vSphere Web Client, select local files including the updated OVF descriptor and merged disk.
  5. If using OVA template, reassemble it from the vSphere Web Client with these steps:
    1. Export the OVF template. This should return ovf file (*.ovf), manifest (*.mf), and virtual disk (*.vmdk). The manifest will be different than before.
    2. Combine the files into a single OVA using a tar utility (ex. tar cvf).

      For example, on Linux:

      tar cvf <vm>.ova <vm>.ovf <vm>.mf <vm>.disk1.vmdk

 


Alternatively deploy the ova/ovf directly from the host UI from the Create/Register VM option and selecting the Deploy VM from a OVx file.

Advertisements

Backup All SQL Server Databases

How to Backup All SQL Server Databases

  1. Specify path to store database backups
  2. Specify backup file name format
  3. Select list of databases to backup
  4. Loop through databases
  5. Programmatically create database backup command using database name, path and file name format

File Naming Format DBname_YYYYDDMM.BAK

Here is the script that will allow you to backup each database within your instance of SQL Server.  You will need to change the @path to the appropriate backup directory.

DECLARE @name VARCHAR(50) -- database name  
DECLARE @path VARCHAR(256) -- path for backup files  
DECLARE @fileName VARCHAR(256) -- filename for backup  
DECLARE @fileDate VARCHAR(20) -- used for file name
 
-- specify database backup directory
SET @path = 'C:\Backup\'  
 
-- specify filename format
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) + REPLACE(CONVERT(VARCHAR(20),GETDATE(),108),':','')
 
DECLARE db_cursor CURSOR READ_ONLY FOR  
SELECT name 
FROM master.dbo.sysdatabases 
WHERE name NOT IN ('master','model','msdb','tempdb')  -- exclude these databases
 
OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @name   
 
WHILE @@FETCH_STATUS = 0   
BEGIN   
   SET @fileName = @path + @name + '_' + @fileDate + '.BAK'  
   BACKUP DATABASE @name TO DISK = @fileName  
 
   FETCH NEXT FROM db_cursor INTO @name   
END   
 
CLOSE db_cursor   
DEALLOCATE db_cursor
Source ..
https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/

VMware KB Certificate replacement (LINKAGE)

VMware Knowledge Base

The VMware Knowledge Base provides support for VMware products.

The following VMware Knowledge Base topics provide information about how to manage certificates