aahh, so I did indeed overlook somewhere obvious.

Thank you.

D.

Hello,

I worked it out in the end, I was leaving the .ldf on the end. As it turned out I got a much better result shrinking the database instead, but...

Hello, I tried to run the DBCC command, but got the following error.

Server: Msg 8985, Level 16, State 1, Line 1

Could not locate file 'D:\foldername\DB\filename_log.ldf' in sysfiles.

DBCC execution completed. If...

Thanks for your replys, I shall have to do the extra steps tomorrow. I did have maintenance plans in place but reorganized them, I have obviously missed something somewhere.

Kind Regards,

D.

hello,

Well, you get a number of scenarios, like a little background info, their plans etc, then you answer between 8-12 questions on each scenario, of which I am guessing is...

Hello,

Thanks for your replies, in the end I had to reinstall the system anyway, because I decided to put VMware on it and it didnt have enough space to install...

Hello, Thanks for the reply.

I have had a good look already but I do not find anything that is specifically related to this problem. I wonder if it may be...

Hello,

Firstly thanks for your replies, they are all helpful as usual. Noel, when you say 'De-Couple', how would this be achieved? I should point out that this will be my...

Hello,

Firstly, thank you for taking the time to answer. I didnt think anyone was going to answer this thread after a dry spell, so I also posted it under the...

Hello,

This must be the most helpful forum ever!

I have another question regarding the SSMA, once you have migrated your access databases over to SQL 2005, is it then possible to...

Congrats Todd,

443 is what I am currently studying for, could you tell me if you used Transcenders? I have used them on other occasions, lately they dont seem to be...

Hello,

Firstly, thank you all for your advice and suggestions, I now have a clear idea of what I need to look into which is great and I now have something...

Thanks for your reply, there were a couple of things I was going to do but, after reading your post, I have already realised some things I had in mind...