topic Re: AiO SB600c and Data Volume in Network Attached Storage (NAS) - Enterprise

AiO SB600c and Data Volume

Tom Lipovz — Tue, 18 Nov 2008 08:21:06 GMT

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!

Re: AiO SB600c and Data Volume

David Straw — Wed, 19 Nov 2008 22:26:07 GMT

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

Re: AiO SB600c and Data Volume

Tom Lipovz — Thu, 20 Nov 2008 07:23:12 GMT

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

Re: AiO SB600c and Data Volume

David Straw — Thu, 20 Nov 2008 16:14:14 GMT

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

Re: AiO SB600c and Data Volume

Tom Lipovz — Fri, 21 Nov 2008 07:23:10 GMT

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

Re: AiO SB600c and Data Volume

David Straw — Fri, 21 Nov 2008 15:12:53 GMT

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

Re: AiO SB600c and Data Volume

Tom Lipovz — Mon, 24 Nov 2008 07:15:21 GMT

David,

Thanks again for your help!

Tom