Search

Language:  
Search for:

Available article translations:

MSSQL does not work in a cloned container or after c2v migration.

APPLIES TO:
  • Parallels Cloud Server
  • Parallels Virtuozzo Containers for Windows
  • Parallels Server

Symptoms

MSSQL server does not work after a container is cloned:

Cannot connect to localhost

You can also see the following entries in the event viewer:

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x29cd2a3a; actual: 0xa83049bb). It occurred during a read of page (1:318) in database ID 1 at offset 0x0000000027c000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

The same symptoms can be observed in a VM after a c2v migration procedure.

Cause

While cloning a container, Security Identifiers are changed on block devices of the container and SIDs are also changed inside SQL master database files.

Resolution

As a workaround, you can move *.mdf and *.ldf files from the source container to the destination VM/container. You can use the following commands to copy the files from the container #111 to the container #112:

C:\>copy "c:\vz\private\111\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\*.mdf" "c:\vz\private\112\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\" /Y

C:\>copy "c:\vz\private\111\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\*.ldf" "c:\vz\private\112\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\" /Y

If you migrate a container to a virtual machine, follow these steps:

  1. Mount the virtual machine:

    ~# prlctl mount myvm
    
  2. Find the mountpoint of the proper partition in the output of this command (there can be few, e.g. if the bootloader is on the separate partition):

    ~# prlctl mount myvm --list
    

    (Substitute myvm with the real virtual machine's name.)

  3. Copy *.mdf and *.ldf files from the source container to the directory /vz/mnt/\{ba5d9b48-a68b-4b5f-a5de-195433d1b5fe\}/volume_1/Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\.

    where /vz/mnt/\{ba5d9b48-a68b-4b5f-a5de-195433d1b5fe\}/volume_1/ is the mountpoint of the proper partition which contains the installation of Windows in this VM.

    To copy files from the source Windows system to the server with PSBM 5.0 or PCS 6.0, the tool pscp from the distribution of PuTTY can be used.

    C:\>pscp "c:\vz\private\111\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\*.mdf" "c:\vz\private\111\root\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\*.ldf" root@PSBM.NODE:/vz/mnt/\{ba5d9b48-a68b-4b5f-a5de-195433d1b5fe\}/volume_1/Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\
    

    (Replace PSBM.NODE with the appropriate server's hostname or IP address; c:\vz\private\111 with the proper path to the container's private area.)

Search words:

Cannot connect to localhost

can't access MSSQL when migrating the container to VM

SQL Server detected a logical consistency-based I/O error: incorrect checksum




909d99074e442b52ce54cc7b31cf065d 2897d76d56d2010f4e3a28f864d69223 4542fc1e09dcc36ad9dbfd547b6b7b3c bf1c3a170005eae151f49ba2720abde9 ca05eaf5b843fbd53589c90d7228a6df

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Desktop Virtualization
- Parallels Desktop 8 for Mac
- Parallels Transporter
- Parallels Desktop Switch to Mac Edition
- Parallels Desktop for Mac Enterprise Edition
- Parallels Management-Mac for Microsoft SCCM
Server Virtualization
- Parallels Cloud Server
- Parallels Containers for Windows 6.0 Beta
- Parallels Virtuozzo Containers
Automation
- Parallels Automation
- Parallels Automation for Cloud Infrastructure
- Parallels Business Automation Standard
- Parallels Virtual Automation
- Parallels Plesk Panel Suite
- Web Presence Builder
- Parallels Plesk Automation
- Parallels Small Business Panel
- Value-added Services for Hosters
- Parallels Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification