make sure there are no open transactions before shrinking the log, also insted of using 1000 try ,0 this will take it down to what ever space is free not...

try this

1) dbcc opentran(dbname) - this will show the oldest open transaction

2) Kill this process

3) backup log dbname with no_log

4) use dbname

5) dbcc shrinkfile(dbname_log,100)...

Cool that is good, I like this program i have not seen one like it so had to write it, where i work we have around 100 sqlservers and its...

Hi there,

You will need to create a file called file.txt or rename file.txt to say sqlserverlist.txt or something.

Then you will need to list all your sqlservers in that file....

I live in Japan, so the credit crunch has not really hit here yet, I am kind of likeing it at the moment as its really good for us to...

I would, but the stupid people before me have no backups.

hehe stupid so instead of reinstalling MOM i thought I would ask someone if they have scripted it out.

DTS or BCP thats the only way. really

Regards,

Terry

Thanks guys and girls, I will do that take him to the park or something, its quite warm now, so maybe I can take a picnic. cheers again

Terry

Wii fit now this game is cool, I thought it would be easy and stupid but damn some of the exersises do give you a good work-out I was sweating...

I am not sure what this error is, I get it myself with logshipping and cant work it out. The log-shipping works for a while and the user does have...

This should be what you need

$file = get-content "G:\Infrastructure\DBA\NewDocs\Terry Powershell\SQLTokyo.txt

# checks file if not found then terminates

if (-not($file))

{

write-error($file+ " not found. Terminating .... ");

exit

}

#...

does not seem to hard, start with create database create table and so on. hehe

good luck

I would go with an IT guy

yep thats always the way, I would love a tvr but I will never get one. 😉

the uk the land of good music, the chav, very nice beer and good food.