Restore Troubleshooting - Sybase IntelliSnap

SYB0010: A Sybase IntelliSnap Restore Fails When Disk Mirroring is Enabled

Symptom

Sybase does not support quiescing the database when the disk mirroring feature is enabled, so the IntelliSnap restore fails.

Resolution

Before you perform the restore, perform the following tasks.

1. Unmirror the disk by using the "retain" mode.

2. Disable disk mirroring

3. Restart the Sybase server.

4. Perform the restore.

5. Enable Disk Mirroring

6. Restart the Sybase server.

7. Manually add a mirror name for the sysdevices

8. Remirror the disk.

9. Restart the Sybase server.

Unmirror the Disk Example

The name of the mirrored device is sybase1.

1>disk unmirror name=sybase1 
 2>go 
 1>sp_configure "disable disk mirroring",1
 2>go

Enable Disk Mirroring Example

1> sp_configure "disable disk mirroring",0 
 2> go

Manually Add the Mirror Name and Remirror the Disk Example

The name of the mirrored device is sybase1.

The mirror name is /sybasesnap/sybasedata1mirror.dat.

1>sp_configure "allow updates" ,1 
 2>go 
 1> update sysdevices set mirrorname="/sybasesnap/sybase1mirror.dat" 
 2> go 
 (1 row affected) 
 1> disk remirror 
 2> name="sybase1" 
 3> go