How much disk space do you have for SIMS.net?

[wesleyw]

Do you sometimes think the world is against you though indiegirl? If even your NM is an incompetent what chance have you with the teaching staff?

 

Wes

[wesleyw]

Windows Scripting Host is not running?

 

No comment!

 

Wes

[indiegirl]

It pays to grumble... here's the solution to shrinking the ldf file:

 

Query Analyzer time (best done with the sa login and password, but guess what I don't have??? - so done with Administrator):

 

on the SIMS database, execute the following query:

 

backup log sims with no_log

dbcc shrinkdatabase (sims, 0)

 

105Gb free, ldf file now 1mb.

 

Backup time!!!!!

[wesleyw]

Removed!!!!

[DMcCoy]

Good to hear!

 

I was going to suggest that, as I've just been reading up on it, I only know general sql and not the more technical stuff. I didn't know if you had the query analyser as I'm not sure if it comes with msde (we were all given msde - although our school changed to full sql). As the normal sims backup truncates too, we just have to hope the full backups we get are good, although I see no practical way for a school to look after a full transcation log and its backup sensibly.

[DMcCoy]

More info here http://support.microsoft.com/kb/873235/EN-US/

 

Oh, and you might not want to broadcast the SA password wesley. I would have done a drop database sims; by now if I was a student

[DMcCoy]

I've just checked, its not the SA password round here, although I did work out what ours is.

[indiegirl]

it's not that password here either. I know this as NM changed it in the summer, and then spent 1/2 a day phoning the dude who he hauled in to set the system up to try and find out what it was.

 

The world against me? Nah, I'm just extremely unlucky in my choice of jobs (the pattern so far is one good, one bad, one good, one bad...) things can only get better :-D

[wesleyw]

Okay, I'm having such fun being wrong

 

Yeah wasn't thinking there I've deleted that now!

 

 

Wes

[NetworkGeezer]

I've just checked, its not the SA password round here, although I did work out what ours is.

 

Yes, I don't remember there being a preset sa password when installing SQL Server on the SIMS server.

 

You're normally given a choice.

[wesleyw]

I thought you were supposed to follow certain guidelines for this but I could be wrong (Won't be the first time today!)

 

Wes

[indiegirl]

Listen guys, thank you so much for all of your help (and replies, and views, and support) today. It's days like this that I am grateful for people like you out there with the spare time to assist. Your help has been priceless today.

 

I can only take from this that I've learned a lot (but still have so much more to go!) on the SIMS front... but I think we can all safely say that I'm a step or two ahead of the NM now...

 

Cheers - have a good evening.

[DMcCoy]

I'm not following any guidelines from capita tyvm

 

I know it, the lea support team knows it, and its in the magic black book. This is all that should be needed. Besides you can change it as administrator if it in mixed mode afaik

[NetworkGeezer]

I thought you were supposed to follow certain guidelines for this but I could be wrong (Won't be the first time today!)

 

Wes

 

No one body told me. That would be like Microsoft telling everyone to use a standard domain admin password.

[wesleyw]

Well as long as there's a way back from the abbyss I think that'll be fine. Thanks though DMcCoy and NetworkGeezer I've actually learnt somethings about SIMS today which will definitely be very useful in the future! Excellent!

 

Wes

[wesleyw]

Well when you say it that way :oops:

 

Still in the end the NM there needs to be found a job within their capabilities such as a litter picker?

 

Wes

[StueyBUK]

Just had to shrink the sims.ldf file here, worked a treat. Thanks for all the info guys.

Stu.