jman642

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • Avatar
    jman642
    Member
    in reply to: Raid 5 #389132
    babu farooq;n490501 wrote:
    Gentlemen ,
    today i have configured raid 5 on my hp server , what my question is shall i make two partition if i make it will i loose raid 5 feature ? please explain .

    If you are talking about hardware RAID, No, you will not.

    You can create two Windows partitions but that’s a logic change. Think about Win partitions as 2nd layer or ways to split available space. Your RAID is the 1st layer. Anything on top of your physical layer will remain on RAID5.

    Avatar
    jman642
    Member

    Sorry for the late reply, lol…

    This was my solution, which works like a charm:

    PushD “\server1.xx.comShareshare_server1” &&(“forfiles.exe” /S /M “*DIFF*.sqb” /d -1 /c “cmd /c del @file”) & PopD
    It runs on my SQL server via TSQL job against the backup server.

    Avatar
    jman642
    Member
    in reply to: How can I unmount a Windows’s volume? #389130

    Re: How can I unmount a Windows’s volume?

    JeremyW;278727 wrote:
    Not sure why the GUI is behaving that way. :???:

    If you’re just changing the name of the folder then after removing the old mountpoint SQL_Data, can you just rename the SQL_Data2 to SQL_Data in Windows Explorer? That’s how I change the names of mountpoints.

    Can I? I mean … I though that with mountpoints, I need to unmount 1st, before renaming.

    For my actual change, following weeks, I will got for the command prompt option, I think it’s safer and probably faster.

    Via GUI, I will test what you suggested, this way:

    -Shutting down SQL
    -Rename E:SQL_Data to E:SQL_Data_OLD
    -Rename E:SQL_Data2 to E:SQL_Data
    -Start MS-SQL, which will now see the new LUN with new mdf files inside.

    If I can do that, that may avoid the unmounting step altogether …

    Avatar
    jman642
    Member
    in reply to: How can I unmount a Windows’s volume? #389129

    Re: How can I unmount a Windows’s volume?

    JeremyW;278671 wrote:
    I guess you’re using a mount point, correct?

    In step 2 are you removing the mountpoint? You should be able to do that and not lose any data. Once the mount point is removed, anything you do to the folder shouldn’t affect the old LUN… but you can offline it just to be safe. ;)

    hey there, thanks for reply.

    I was using the GUI and removing the mount point, yes. But after doing that, if I try to attach the new LUN to the existing mount point or folder, I get an error.

    I did additional test yesterday using “mountvol” commmand and it worked. But I am curious to know why it does not when using the GUI.

    Command line, this is what I did:

    mountvol E:SQL_Data2 /d
    mountvol E:SQL_Data /d
    mountvol E:SQL_Data \?Volume{volume id here, the one that was under E:SQL_Data2, blah, blah, blah, etc}
    [/CODE]

    It does not destroy the data, of course, as I am only unmounting. But the third and last step is the one that I can’t via GUI.[CODE]
    mountvol E:SQL_Data2 /d
    mountvol E:SQL_Data /d
    mountvol E:SQL_Data \?Volume{volume id here, the one that was under E:SQL_Data2, blah, blah, blah, etc}
    [/CODE]

    It does not destroy the data, of course, as I am only unmounting. But the third and last step is the one that I can’t via GUI.

    Avatar
    jman642
    Member

    Re: Windows server 2012 (SQL 2012) kinda froze on HP DL580G7 with no event entries

    What else did you install on that box? Are you running SQL 2012 alone? What CU or Service Pack of Windows do you have?

    Avatar
    jman642
    Member
    in reply to: Virtual ISCSI SAN Disk for VMware workstation #389127

    Re: Virtual ISCSI SAN Disk for VMware workstation

    Thank you guys for your replies.

Viewing 6 posts - 1 through 6 (of 6 total)