AiO SB600c and Data Volume

[Tom Lipovz]

I am trying to migrate SQL database from original server (BL460c) to AiO SB600c storage using wizzard. When done, Data Volume folder is created on original system's disk, populated with the database, instead on the storage. No errors or warnings reported. Any ideas welcome!

[David Straw]

Tom,

Was an iSCSI disk created? To check, right-click on My Computer and select Manage. Under Storage > Microsoft iSCSI Software Target > Devices, is there a virtual disk there with the description, "ASM auto-generated disk. Do not modify."?

Also, what does All-in-One Storage Manager report as the volume mount paths for the database components? In ASM, right-click a data file in the database and go to Properties, then Storage.

David

[Tom Lipovz]

David,

Thanks for reply! Yes, iSCSI disks are created, both for SQL data and log file, but application server volume mount paths for both point to "C:/Data Volumes/..." on originator's disk instead to newly created iSCSI disk.

Strange thing is, I've already have one database on storage, created by wizzard without problem.

Regards, Tom

[David Straw · Accepted solution]

Tom,

By default in recent versions, All-in-One Storage Manager mounts the iSCSI drives under C:\Data Volumes\, so it sounds like the data is in the correct folder. However if the volume isn't actually mounted then that's a problem. Do the folders under C:\Data Volumes\ show up as mount points (different icon in Windows Explorer) or are they local folders?

David

[Tom Lipovz]

David,

Now, this is something new! Folders under C:\Data Volumes\ indeed show up as different icons, mount points I presume. So, just to be sure, actual space is occupied on the storage, but on the originating server is visible as a mounting point in the folder above, am I right?

Is there any problem if I have a mix of old and new version concpets, since one of may previous database is mounted as "drive letter" disk?

Thanks again for the explanation!

Tom

[David Straw]

Tom,

That's exactly right. The data is stored on the storage server and mounted in a folder on your C: drive.

There is no problem having both mount points and drive letters. In fact, if you want you can still specify that you want ASM to create drive letters for you in the Advanced storage dialog while migrating data. ASM now defaults to mount points to accommodate cases where there are more iSCSI Disks than there are available drive letters.

David

[Tom Lipovz]

David,

Thanks again for your help!

Tom