IRC Logs

Network: freenode Channel: #csharp

	Enter your search terms Submit search form
	Web www.irclog.org

[16:56]<zyccus>I keep hearing about, or dealing with, corruptions of SQL Server databases
[16:56]<zyccus>it seems a little... fragile, at time
[16:56]<zyccus>+s
[16:56]<mjzymygo>Rikkus: only happens on DB's not looked after properly.
[16:57]<mjzymygo>happens just as often on oracle under similar circumstances
[16:57]<mjzymygo>and DB2 from what I saw once
[16:58]<zyccus>define 'looked after properly'
[16:58]<mjzymygo>weekly auto maintenance schedules.
[16:58]<mjzymygo>monthly manual checks
[16:58]<mjzymygo>optimisations
[16:58]<mjzymygo>(query optimisation that is)
[16:58]<mjzymygo>oh... and a reliable backup system is always good
[16:59]<mjzymygo>including keeping the transaction log and database file on seperate drives (physically seperate)
[16:59]<mjzymygo>you know... general DBA work..
[16:59]<zyccus>we basically provide a backup system... and that's it
[17:00]<mjzymygo>rikkus: on DB's reaching 2GB... i'd re-think that
[17:00]<zyccus>I would love to have our databases looked after... unfortunately we can't send a DBA with our software
[17:00]<zyccus>that would put the price up somewhat
[17:01]<mjzymygo>but you can at least script scheduled tasks to run off the agent
[17:01]<zyccus>could do... would be nice to at least run checks every day and warn the user next time they log into the app if there's been some trouble
[17:01]<zyccus>which wasn't fixable
[17:01]<mjzymygo>rikkus: once a week would be enough
[17:01]<zyccus>unfortunately SQL Server Agent doesn't work when we install MSDE
[17:02]<mjzymygo>ah... MSDE.
[17:02]<zyccus>just fails to start
[17:02]<mjzymygo>then your on grace and favour
[17:03]<mjzymygo>although you could get your app to fire off a small util every now and then that runs the scripts
[17:03]<mjzymygo>or even install a windows server that does it
[17:03]<mjzymygo>(service)*
[17:03]<zyccus>scheduled task would be fine
[17:04]<mjzymygo>see... even with MSDE you can run some auto maintenance.
[17:04]<zyccus>perhaps that sort of stuff could even be done along with backups
[17:04]<mjzymygo>it would extend the life of the DB exponentially
[17:12]<svzz[wjzc]>hey guys it's me again (yayyyy) again with my binding that doesn't update, here i made the summary of the problem with a bit of code : http://rafb.net/paste/results/tdLYFj70.html
[17:13]<mjzymygo>Staz: I forget: you dealing with SQL-Server?
[17:13]<svzz[wjzc]>yes
[17:13]<mjzymygo>Do you know how to use SQL Profiler?
[17:13]<svzz[wjzc]>nope
[17:14]<afd>hmm
[17:14]<mjzymygo>Staz: well.. load it up, connect to the DB server your wanna check
[17:14]<afd>you can't use profiler with 2005 express :-/
[17:14]<svzz[wjzc]>oh...
[17:14]<mjzymygo>AqD: thats strange. I can
[17:14]<svzz[wjzc]>i'll have to find something else then
[17:14]<afd>Moridin8: how you use it??
[17:15]<mjzymygo>I tell it to connect to SQL 2005 express ???
[17:15]<afd>use what profiler??
[17:15]<afd>sql 2000's?
[17:15]<mjzymygo>yeh
[17:15]<mjzymygo>no... 2005's
[17:15]<mjzymygo>;)
[17:15]<afd>but it says version is not correct..
[17:15]<afd>ah
[17:15]<afd>but i can't install it with express
[17:16]<mjzymygo>I keep forgetting some people ain't got access to MSDN subscriptions
[17:16]<svzz[wjzc]>so... i can or not?
[17:16]<afd>Moridin8: i have access to sql server 2005 anyway ;)
[17:16]<afd>Moridin8: but the setup refuse to run because express is there
[17:16]<mjzymygo>Staz: do you have access to Sql Server Management studio? (2005 clients)
[17:16]<mjzymygo>AqD: then install as a different instance.
[17:17]<svzz[wjzc]>mopos yes
[17:17]<svzz[wjzc]>Moridin8 yes
[17:17]<svzz[wjzc]>mopos -> misstype
[17:17]<afd>Moridin8: no i'm not going to install an db
[17:17]<afd>jsu tools
[17:17]<djljs>?
[17:17]<mjzymygo>I have Sql MSDE/SQL 2k Dev/Sql 2k Standard/Sql 2k Ent/2005 Express/2005 Standard/2005 Ent all installed on my machine running side my side
[17:18]<mjzymygo>Staz: Then install the 2005 clients and fire up profiler.
[17:18]<svzz[wjzc]>2005 client... of SQL profiler?
[17:18]<mjzymygo>You can install the SQL 2005 clients without installing the DB server.
[17:19]<afd>Moridin8: but the setup says no
[17:19]<svzz[wjzc]>i know i did that
[17:19]<afd>it said so before i choose tools or db
[17:19]<mjzymygo>if you install SQL Management Studio and SQL Profiler you will be able to monitor the DB activity
[17:19]<mjzymygo>AQD: then your installation is working correctly.
[17:19]<mjzymygo>(is not working correctly)
[17:19]<afd>ah
[17:19]<mjzymygo>Staz: so you have Sql Profiler 2005 installed?
[17:20]<svzz[wjzc]>huh no
[17:20]<svzz[wjzc]>i'm searching where to d/l it actually
[17:20]<mjzymygo>Staz: sorry... I think I got confused.
[17:21]<mjzymygo>Staz: torrent it from somewhere (disclaimer: Moridin8 did not say this... it was the Pixie from under the next door neighbours cesspit)
[17:21]<svzz[wjzc]>lôl
[17:22]<mjzymygo>Staz: so get your company to pay £500 and become an official M$ ISV and get proper MSDN subscription for 5 developers
[17:23]<svzz[wjzc]>ouch¸
[17:23]<svzz[wjzc]>no way my boss will pay that
[17:23]<svzz[wjzc]>:(
[17:23]<mjzymygo>five hundred pounds of taz-deductable cash to become LEGAL?
[17:23]<mjzymygo>(taz = tax)
[17:23]<mjzymygo>Staz: what country you in?
[17:24]<svzz[wjzc]>CA, and that's $1k
[17:24]<mjzymygo>Erm... I thought software required for business was tax deductable in the states too... ??
[17:24]<svzz[wjzc]>huh sorry
[17:24]<svzz[wjzc]>CA as in Canada
[17:25]<zyccus>I think it might be a good time to leave that company
[17:25]<svzz[wjzc]>well i won't do that :P
[17:25]<mjzymygo>Staz: I'm not sure about the law in Canada on software tax deduction...
[17:25]<zyccus>well this isn't #microsoft-warez
[17:25]<svzz[wjzc]>i,ll try to trick out my SP to print something in a table to see if it gets fired
[17:25]<svzz[wjzc]>Moridin8 i doubt it VERY MUCH that it's tax deductable here

Back to #csharp
Or go to some related logs:
#gentoo
#debian
#php
#cisco
#netbsd