TRUNCATE TABLE <table> will be faster, especially for big tables. But this is going OT :-)
Cheers Ken ________________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Desmond Sent: Thursday, 29 June 2006 3:05 PM To: [email protected] Subject: RE: [ActiveDir] NTFS ( 16 Exabyte's ) Jose- Take a look at Veritas Storage Foundation for this. It works with MSCS and gives you a lot more control in this type of situation. Alternatively DELETE FROM BigTable GO exec dbcc_shrinkFile [BigDB], 10 Thanks, Brian Desmond [EMAIL PROTECTED] c - 312.731.3132 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jose Medeiros Sent: Thursday, June 29, 2006 12:01 AM To: [email protected] Subject: Re: [ActiveDir] NTFS ( 16 Exabyte's ) Hi Steve, Thank you for the reply. I was not aware of a GPT disk on X64. I realize that I two terrabyte volume is large, however the group that I am suporting has a database that is close to 4 terrabytes, and have asked for the largest volume available. Thank you for taking the time to reply, Jose :-) ----- Original Message ----- From: Steve Linehan To: [email protected] Sent: Wednesday, June 28, 2006 7:54 PM Subject: RE: [ActiveDir] NTFS ( 16 Exabyte's ) Jose, This is due to the fact that MBR disks are limited to 2 TB in size. You would need to go to GPT disks to see a larger disk, http://www.microsoft.com/whdc/device/storage/GPT-on-x64.mspx . Unfortunately we do not support GPT disks on cluster servers at this time for the shared disks. As far as corruption we have customers running much larger volumes and the biggest concern is disaster recovery times. Thanks, -Steve From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose Sent: Wednesday, June 28, 2006 9:22 PM To: [email protected] Subject: [ActiveDir] NTFS ( 16 Exabyte's ) Greetings, Quick question. I just finished building two new 2003 servers running Microsoft Clustering services and presented two 2047 Gigabyte LUNS to each cluster node. However, the OS is only seeing 1.99 Terabytes (Please see my screen capture). I specifically recall from my Microsoft NT 3.51 server class taught by Michael Van Dercreek at Technology Education Centers back in 1996 using official MOC, that NTFS is a 64 bit file system ( 2 to the 64th power = 16 Exabytes ). 16 Exabyte's is the largest partition available on NT 3.51, however I do not seem to recall if this has been changed in 2003, since I have only taken a course on Active Directory 2003, Exchange 2003, SQL 2005 and ISA 2004. So why I am only seeing 1.99 TB on a 2.47 TB LUN? Is any one else running a larger LUN size using NTFS? Any issues or corruption of the MFT that I should know about? My apologies in advance for the newbie question ( I really should know this answer ). Sincerely, Jose Medeiros Storage Area Network Systems Engineer MCP+I, MCSE, NT4 MCT 408-765-0437 Direct, 408-449-6621 Cell "Anyone who has never made a mistake has never tried anything new." Albert Einstein List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ml/threads.aspx
