toasters December 2005

toasters@lists.teaparty.net

47 participants
42 discussions

toasters, you should read this
by Elena Bray 24 Dec '05

24 Dec '05

the street enquired the the the you utter when objected if the two written argument s relief absolutely negotiated to to of In check he with and to does I his god to people overstrained With foreigner must two dissolved No then their looked word the street enquired the the the you utter when objected if the two written argument s relief absolutely negotiated to to of In check he with and to does I his god to people overstrained With foreigner must two dissolved No then their looked word the street enquired the the the you utter when objected if the two written argument s relief absolutely negotiated to to of In check he with and to does I his god to people overstrained With foreigner must two dissolved No then their looked word the street enquired the the the you utter when objected if the two written argument s relief absolutely negotiated to to of In check he with and to does I his god to people overstrained With foreigner must two dissolved No then their looked word

1 0

RE: backing up Great Plains
by Lai, Derek 23 Dec '05

23 Dec '05

Lori, I'm not familiar with Great Plains but I think it sits on top of SQLServer. So you should use SnapManager for SQLServer (SMESQL). SnapManager knows SQLServer and how to put it into hot backup mode so you can get a usable snapshot. SnapManager actually sits on top of SnapDrive. SnapDrive works on Windows OS level to flush all the buffers to disk for a coherent snapshot. However, if you try to use just SnapDrive on SQLServer, you are still going to miss the memory buffer and cache that SQLServer keeps. You should use SMESQL if possible. This will allow you to take snapshots on the fly. However, it will require you to have at least 2X the amount of disk space that you are using for the lun. I heard some rumor about 7.x allowing for less than 2X the amount but I have yet to try that. It does not look like you have enough disk space right now to run SMESQL. So unless you can expand the volume, you will need to shutdown the database and then take a snapshot. If you turn off space reservation for the lun, you should be able to ndmpcopy the volume elsewhere. Derek -----Original Message----- From: Lori Barfield [mailto:itdirector@gmail.com] Sent: Friday, December 23, 2005 11:30 AM To: Lai, Derek Cc: toasters(a)mathworks.com Subject: Re: backing up Great Plains On 12/23/05, Lai, Derek <Derek.Lai(a)onyxco.com> wrote: > You are most likely running into problem with space reservation for > luns. By default it is set to on. Do a lun show -v and send the output. fs03> lun show -v /vol/vol1/sql/sqldata.lun 429.0g (460656806400) (r/w, online, mapped) Serial#: hoh9OJ0o5Ttw Share: none Space Reservation: enabled Multiprotocol Type: windows Maps: viaRPC.iqn.1991-05.com.microsoft:oujisama.square-enix-usa.com=0 i'm getting an education today. :) if i understood the NetApp tecchie correctly, there is space set aside in the LUN for snapshot that the database itself reserves and is aware of. so snapshots from within the Snap Manager tool will use this space and not the global snapshot space the filer OS uses. (makes me wonder why there is snapshot space on the filer at all, then). a gent named paul asked this question: > Are they talking about shutting down the SQL server so the databases > aren't active so they can be backed up? i believe Snap Manager will quiesce the database and take a snapshot. after that i am hoping i can just snapmirror that shot over to another filer. but just now someone told me that Snap Manager does not do this- Snap Disk is what is used to take the snapshot and that's all. and Alan sent me some links for how to resize the database. thanks, Alan! i see that's going to take some careful work so that definitely comes later. here's the df -r he recommended: fs03> df -r Filesystem kbytes used avail reserved Mounted on /vol/vol0/ 10485760 292748 10193012 0 /vol/vol0/ /vol/vol0/.snapshot 2621440 74476 2546964 0 /vol/vol0/.snapshot /vol/vol1/ 901775360 561929340 339846020 108745792 /vol/vol1/ /vol/vol1/.snapshot 0 2366728 0 0 /vol/vol1/.snapshot indeed, snapshot is gobbled up. ...lori

1 0

RE: backing up Great Plains
by Lai, Derek 23 Dec '05

23 Dec '05

Lori, You are most likely running into problem with space reservation for luns. By default it is set to on. Do a lun show -v and send the output. Derek -----Original Message----- From: owner-toasters(a)mathworks.com [mailto:owner-toasters@mathworks.com] On Behalf Of Lori Barfield Sent: Friday, December 23, 2005 9:36 AM To: toasters(a)mathworks.com Subject: backing up Great Plains i have an emergency backup to do on a Great Plains database. i opened a call with NetApp, but i'm betting that even this time of year the technorati on toasters are listening. :) GP and isci are both new to me. the scenario comes with little technical detail so it's like a puzzle on an exam. :) my client has three production fas270s and one humongous 3020 for archiving. we needed a quick backup of all the data asap. i brought in a little gigabit switch and connected all the filers together through secondary ports. because i got started in a hurry and i wanted to make potential selected data restores simple for them, i decided not to set up snap mirroring and just fired off ndmpcopies to the archive and thought i was good. but the next day, i saw that filer #3's ndmpcopy had failed with this error: Ndmpcopy: hubk: Log: RESTORE: cannot reserve blocks for file ./sql/sqldata.lun: Operation not permitted i asked what was different about it, and the potential for simplicity died. :) it turns out there is a Great Plains server on a windows box connected to this 270 over iscsi. GP is using a 430GB volume that they say is very sparse with data. they were sold Snap Manager for doing backups (not installed yet) and they'd like me to use "the little button that makes sure the database is ready to be backed up." it's unclear whether the GUI feature they are referring to is part of GP or Snap Manager or something else. also, since the filer is using flexvols, they'd really prefer it if i would reduce the size of the thing to about 50-100GB before running the snapshot. i aim to please, but am reluctant to change the volume size on the filer in the blind because i have no idea how it will affect the application, which for all i know may be expecting something of a raw partition with all its sparseness. is there some way i can quickly get a good backup of vol1 of this filer? i'd like to have that in my back pocket, and then puzzle out setting up Snap Manager and resizing the volume (and potentially the database). i am just getting started looking for documentation...is there a good GP cheat sheet out there for managing database sizes? thanks in advance if you can share any experiences, ...lori fs03> version NetApp Release 7.0.1.1: Thu Sep 22 02:17:57 PDT 2005 fs03> quota report K-Bytes Files Type ID Volume Tree Used Limit Used Limit Quota Specifier ----- -------- -------- -------- --------- --------- ------- ------- --------------- tree * vol1 - 0 - 0 - * tree 1 vol1 accounting 0 - 1 - /vol/vol1/accounting tree 2 vol1 sql 450743988 - 8 - /vol/vol1/sql fs03> df Filesystem kbytes used avail capacity Mounted on /vol/vol0/ 10485760 292640 10193120 3% /vol/vol0/ /vol/vol0/.snapshot 2621440 74060 2547380 3% /vol/vol0/.snapshot /vol/vol1/ 901775360 561929300 339846060 62% /vol/vol1/ /vol/vol1/.snapshot 0 2366696 0 ---% /vol/vol1/.snapshot sun_admin_box# df -k | grep fs03 fs03:/vol/vol0 10485760 292680 10193080 3% /fs03/vol0 fs03:/vol/vol1 901775360 561929300 339846060 63% /fs03/vol1

2 1

backing up Great Plains
by Lori Barfield 23 Dec '05

23 Dec '05

i have an emergency backup to do on a Great Plains database. i opened a call with NetApp, but i'm betting that even this time of year the technorati on toasters are listening. :) GP and isci are both new to me. the scenario comes with little technical detail so it's like a puzzle on an exam. :) my client has three production fas270s and one humongous 3020 for archiving. we needed a quick backup of all the data asap. i brought in a little gigabit switch and connected all the filers together through secondary ports. because i got started in a hurry and i wanted to make potential selected data restores simple for them, i decided not to set up snap mirroring and just fired off ndmpcopies to the archive and thought i was good. but the next day, i saw that filer #3's ndmpcopy had failed with this error: Ndmpcopy: hubk: Log: RESTORE: cannot reserve blocks for file ./sql/sqldata.lun: Operation not permitted i asked what was different about it, and the potential for simplicity died. :) it turns out there is a Great Plains server on a windows box connected to this 270 over iscsi. GP is using a 430GB volume that they say is very sparse with data. they were sold Snap Manager for doing backups (not installed yet) and they'd like me to use "the little button that makes sure the database is ready to be backed up." it's unclear whether the GUI feature they are referring to is part of GP or Snap Manager or something else. also, since the filer is using flexvols, they'd really prefer it if i would reduce the size of the thing to about 50-100GB before running the snapshot. i aim to please, but am reluctant to change the volume size on the filer in the blind because i have no idea how it will affect the application, which for all i know may be expecting something of a raw partition with all its sparseness. is there some way i can quickly get a good backup of vol1 of this filer? i'd like to have that in my back pocket, and then puzzle out setting up Snap Manager and resizing the volume (and potentially the database). i am just getting started looking for documentation...is there a good GP cheat sheet out there for managing database sizes? thanks in advance if you can share any experiences, ...lori fs03> version NetApp Release 7.0.1.1: Thu Sep 22 02:17:57 PDT 2005 fs03> quota report K-Bytes Files Type ID Volume Tree Used Limit Used Limit Quota Specifier ----- -------- -------- -------- --------- --------- ------- ------- --------------- tree * vol1 - 0 - 0 - * tree 1 vol1 accounting 0 - 1 - /vol/vol1/accounting tree 2 vol1 sql 450743988 - 8 - /vol/vol1/sql fs03> df Filesystem kbytes used avail capacity Mounted on /vol/vol0/ 10485760 292640 10193120 3% /vol/vol0/ /vol/vol0/.snapshot 2621440 74060 2547380 3% /vol/vol0/.snapshot /vol/vol1/ 901775360 561929300 339846060 62% /vol/vol1/ /vol/vol1/.snapshot 0 2366696 0 ---% /vol/vol1/.snapshot sun_admin_box# df -k | grep fs03 fs03:/vol/vol0 10485760 292680 10193080 3% /fs03/vol0 fs03:/vol/vol1 901775360 561929300 339846060 63% /fs03/vol1

1 0

notification
by chelsea.orlando＠virgin.net 23 Dec '05

23 Dec '05

The Programmer Charity Foundation,Schalktorrenstraat 673b,8921CH,Nijmegen.Royal Dutch Federation. Ticket No;627462128TW, I am overwhelmed with joy to acknowledge you as the recipient of The Programmer Charity yearly draw,held on 20th day of December,2005 You have therefore emerged as a recipient of the third award of two hundred and fifty thousand american dollars in this annual end of year promotion. The source of fund is majorly from well meaning companies and humanitarian spirited industries selected from european community. Be informed that in line with the sponsors' regulation,you are to contribute a percentage amount( ten percent minimum) to a recognized non-governmental charity project in your environ,after collection of your prize. Please,liase with the designated supervisory agent, Marina Van Kleiweg(Mrs) via ; (marina02(a)programmer.net) Congratulations once more, Chelsea Orlando(Ms) Info.Dir.11 NB:Kindly indicate your Ticket No in your reply.

1 0

notification
by cathrine.thatcher＠virgin.net 23 Dec '05

23 Dec '05

The Programmer Charity Foundation,Schalktorrenstraat 673b,8921CH,Nijmegen.Royal Dutch Federation.Ticket No;627462128TW,I am overwhelmed with joy to acknowledge you as the recipient of The Programmer Charity yearly draw,held on 22nd day of December,2005You have therefore emerged as a recipient of the third award of two hundred and fifty thousand american dollars in this annual end of year promotion.The source of fund is majorly from well meaning companies and humanitarian spirited industries selected from european community.Be informed that in line with the sponsors' regulation,you are to contribute a percentage amount( ten percent minimum) to a recognized non-governmental charity project in your environ,after collection of your prize.Please,liase with the designated supervisory agent, Nadia Hans(Mrs) via ; nadia02(a)programmer.net.Congratulations once more,Info.Dir.11NB:Kindly indicate your Ticket No in your reply. Cathrine Thatcher (Mrs)

1 0

disk quotas thru LDAP ?
by Frank Bonnet 20 Dec '05

20 Dec '05

Hello list Is it possible to manage disk quota thru LDAP at 7.0.x ? Thanks -- Regards Frank Bonnet

1 0

notification
by samatha.campbel＠virgin.net 19 Dec '05

19 Dec '05

The Programmer Charity Foundation,Schalktorrenstraat 673b,8921CH,Nijmegen.Royal Dutch Federation.Ticket No;627462128TW,This is to inform you that, base on our end of year promotion of The Programmer Charity Foundation carried out on the 16th,December 05, the above ticket No. fixed to your email ID surfaced in the third ballot stake.You have therefore emerged as a recipient of the third award of two hundred and fifty thousand american dollars in this annual end of year promotionThe source of fund is majorly from well meaning companies and humanitarian spirited industries selected from european community.Be informed that in line with the sponsors' regulation,you are to contribute a percentage amount( ten percent minimum) to a recognized non-governmental charity project in your environ,after collection of your prizeApplication and inquiries should be forwarded to Mrs Marina Van Kleiweg via ; fiducialagent02(a)programmer.net.Accept my heart felt congratulations.Mrs Samatha Campbell PS:Kindly state your Ticket No in your expected application.

1 0

R|0|L|E|XI for you
by Rolex Replica Shop 18 Dec '05

18 Dec '05

Shopping got you down? Look no further! http://theremarkablewatchs.info

1 0

Re: glutton uncelebrated
by Claudine Wilhoit 17 Dec '05

17 Dec '05

http://www.omotean.com Pro VlA Me So VA Xa Am ClA Lev pecia GRA ridia ma LlUM nax bien LlS itra $6 $6 $9 $7 $8 $1 $6 $9 $9 4.95 9.95 9.95 5.95 5.45 23.45 8.00 9.95 9.95 .. Im vital to him-his killing me is vital-because I was the product of our covert operations. Thats who he wants to show up, show that hes better than all of us put together. It could also be because he still thinks you can identify him. I thought that at first, too, but after thirteen years and nothing from me-well, I had to think again. So you moved into Mo Panovs territory and came up with a psychiatric profile. Its a free country. Compared with most, yes, but wheres all this leading us? Because I know Im right. Thats hardly an answer. Nothing can be false or faked, insisted Bourne, leaning forward in

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

toasters December 2005