Recent content by ninhovid

thanks...

so, if i want to have the same database in a cluster, that will not be possible? only in Active/Pasive mode this could be approached? i don't get the point of having for example 4 sql server instances in a cluster... (4 servers) serving each one of them a different database, if one sql instance...

Hello... thanks for reading, i hope you can help me... I've just configured a load balancing scenario using Virtual Server 2005... i think i could use this (in a production enviroment) when i want to publish a transactional web site, where servers behind this load balancing scenario have...

Hi everybody... I've set up a VPN using w2k server... and its working... but i dont want it to simply authenticate by username and password, so i set up in the same server a CA.. i've installed an RSA server certificate and checked the EAP box in RRAS... i've installed on the client side a...

i have moved that slider... i hope my problems disappear in the mean time with that... meanwhile we are preparing the iis and sql split up... thanks...

i'll check it right away we are planning to separate them... =)

its my web and sql server... the apps are installed on the client side... thanks

yes, i had it for its defaults... i'll play with it... so, it depends on the programs using sql right? about its growing... thanks!

Hi everybody... I have a web server with sql server installed... running vb apps and asps... it has 2 GB of RAM sqlservr.exe is growing up.. right now its 1.8 GB big! what can be happening? i have to stop it and restart it... but in less than an hour its getting bigger again! thanks in...

yeah! it did it and very fast... thank you =)

sorry... i've already posted in setup and admin.... and they have replied i'm using sql server 2000.... thanks

mmmm.. i'm getting this error message... Server: Msg 8985, Level 16, State 1, Line 1 Could not locate file 'db_test' in sysfiles. DBCC execution completed. If DBCC printed error messages, contact your system administrator. what would i be doing wrong?

ok, i'll look for the simple recovery option, and then i'll run your code... i guess its 200 mb right? thanks.. is this dangerous? or not too much because i plan to restore from bak files? thanks again...

hi everybody... i'm having some space problems... i have a database whose log file is almost 7 gb big! (.ldf) how can i reset it? it doesnt matter if i can restore it from logs... i do backups everday (.BAK) and i would restore it that way.. thanks in advance...

hi everybody... i'm having some space problems... i have a database whose log file is almost 7 gb big! (.ldf) how can i reset it? it doesnt matter if i can restore it from logs... i do backups everday (.BAK) and i would restore it that way.. thanks in advance...