| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> Win 2000 pro is ok for a dev machine?
<1> maybe not :)
<1> sure
<1> why shouldn't it be?
<0> will it run sql2000 enterprice?
<1> but depending on the number of connections you need.. it is often limited to 10 connections
<1> nope, don't think so
<0> enterprise
<0> see, sux nuts
<1> it might run the dev. edition
<0> this blows
<0> nah i dont need dev
<1> dunno if dev-edition allows the enterprise stuff
<2> Quant : boo-hoo, pay some money
<2> Quant : ms-sql enterprise will only run on 'server' OS verfsion
<1> can't you get the 180-day trial of the OS ? :D
<3> MSSQL Dev runs on workstatiosn
<2> yup, and ms-sql ent too
<3> workstations
<3> dev edition is ent edition
<3> aside that slight difference that is :)
<4> XOSoft wants us to try out wansync for sql2k5
<4> this might be interesting.
<0> ms-sql ent will run on win2k pro?
<2> Quant : no
<0> <+YuppieScm> yup, and ms-sql ent too
<2> [19:19:10] <1> can't you get the 180-day trial of the OS ? :D
<5> ya enterprise eval will run on 2k pro
<5> but not enterprise retail
<1> and dev edition should be the one to use on the dev machine, to access ent. features
<1> ths ****s horse balls. *sigh*
<4> gotta have a big mouth for those kinda balls
<1> if you say so
<0> rizzard the jizzard
<0> woot
<0> they found the server cd
<1> This is nice. After m***aging back and forth, now I get the correct results. Indicates IUIQ it seems. just irritating that I don't know what the problem was. *sigh*
<0> problem was that cube needed to be refrehsed :)
<6> is there a way in mssql to get the growth history?
<6> this db i'm looking at is around 7MB right now
<6> er
<6> 7000
<6> i need to figure out at what rate it is growing
<5> what do you see in the logs?
<6> on the server tab of course all i have is current stats...
<6> do you mean the actual log files?
<5> no, unles you can read binary
<5> + nd understand it
<6> that won't be happening today
<1> Quant: heh.
<6> while i spin my wheels on that one, how often do you guys typically back up busy dbs?
<1> it depends :)
<6> right now our data is backed up nightly, but...
<6> by friday the db is sluggish
<1> uhm
<6> friday is a fullback up
<1> you are talking about performance issues, not recoverability issues
<2> MadScribe : that's nothing to do with backups
<6> maybe i misunderstand
<6> by friday our transaction log is huge
<2> you should be dumping the t-log with every backup
<6> along comes the backup, transaction log shrinks, everyone stop sending me death threats (i inherited them)
<6> er everyone stops rather
<6> my last job we did that every few hours iirc
<6> for some reason it's not being done that way here
<6> even though this place could only benefit
<2> MadScribe : so there isn't a hot standby server?
<6> if it blew up we'd be dead
<6> it's an emr on top of that
<6> so you can imagine the demons that visit my dreams at night
<6> patient records, gone
<2> MadScribe : so there isn't a hot standby server?
<6> *poof*
<6> nope
<7> my primary DB is being backed up usually 18 hours out of every 24 and trhen any other time its going to tape :P
<2> MadScribe : then that's the problem
<6> so, do you do like a backup and restore to another server?
<6> your hotstand by?
<7> hot backups start at 6pm, finish around 1pm :P
<7> and the next day incrementals and archive log backups run. and the system pulls the full from the server
<2> take the overnight backup and restore it to spare server
<7> and the next day the cycle continues
<2> then copy t-logs across every x minutes
<2> from prd to standby
<6> well, i've been holding up on a ups purchase b/c i keep feeling i needed another sql server, gonna google for some recommended backup practices so when i say i need this ups b/c i need this other machine, i can provide a few other references for my argument
<7> is your sqlserver at 100% load?
<7> you are better off with a good lto3 tape drive and ups and generator
<7> and san
<2> right up until a cpu fails, or the psu goes bang, or...
<2> that said, there are two issues here, one is backups, the other is 'business continuity'
<2> how long can you afford to be down?
<6> we can't go down
<7> lol you cant huh?
<7> and you dont have a ups or generator?
<6> that can't happen, and the previous guy never accounted for that
<6> yah, it'll last all of 2 minutes
<0> rofl
<7> at least with a dead box, you can pop up vmware on a new system and recover it in a few minutes
<0> why cant you go down
<0> what if you decide to move
<6> Quant: i'm trying to get this into a colo asap
<7> if you only have 2 minutes of power and runtime on your ups, a new bigger ups wont give you more than 15 minutes
<6> but for now i have to work with what i'm given and buy as i can
<7> a generator is cheap, and fails over within 5 seconds
<7> how many kva ups you have now, and what will you upgrade to?
<6> rjarett: 24 minutes is about the best i can do on this current power supply
<6> heh, you'd laugh
<6> so I won'
<7> do you have 24x7 system monitoring and notification? how will you know of a power outage or AC breakdown over the weekend? or holiday
<6> t say
<2> "can't go down"? hahahahahahahahahahaha
<8> wtf is 0x3C ... ?
<6> YuppieScm: the last guy wasn't trained to think as a network guy, and he told them that
<6> now i've been stuck with fixing the stuff
<6> and at the same time i'm expected to do full time dev
<0> 03c is a CR char no?
<0> dunno
<0> look it up
<8> how is 0x3C or ... "<" ... invalid ?
<9> x3c = 'c'
<7> MadScribe do you have sprinklers over your servers?
<6> yup, and the tapes are in a fireproof box...
<6> unlocked
<6> on the SECOND floor
<0> rjrett: :)
<0> do you?
<8> I hand created an xml document as a string in C# ... <steps><step><p /><p /></step></steps>
<7> yep gunna cost me 30k to cap those ****ers and put in fm200
<6> lots of things wrong with this
<8> it says the < on the first <p> element is an invalid attribute character ...
<8> oh, duh ... forgot to pu the ' on the last attribute, ...
<6> easiest thing, is to move the production servers to a colo and go from there
<6> but...
<6> they've tied production and office too tightly
<7> MadScribe beleive me... its probably not as bad as others have had to deal with
<6> someone had the brilliant idea to use office objects, so... outlook must be open on the server for the site to work correctly
<10> that's brilliant!
<1> heh. you can integrate woth office on the server - without requiring office to be open on a logged-on user
<1> it takes a bit of tweakin for cleanup, but is doable
<6> Inge: it's gonna have to be done
<6> lots of things they just didn't consider at all
<10> who is "they"?
<7> i came here, and our 18kva ups was at 95% and with the datacenter lights it goes to 98-99%
<7> tape drives were broke, most systems were backing up
<10> why are the lights on the UPS?
<7> no hotbackups
<7> rmah i dunno
<10> that seems rather silly
<7> at least they are flourewscent
<6> rmah: a doctor's office decided to develop an emr hired a software developer and started from there, and they've just sorta hodge-podged together a network
Return to
#sql
or
Go to some related
logs:
frangables
she gots legs
#worldcup
#politics
animeforever.net
#hardware
#sex
#worldcup
#beginner
california homestead act
|
|