I have had better results when I have continued to defrag more than once. Dont know why this happens. What I also try to do is delete (IF I CAN!)...

try this article:-

http://www.sql-server-performance.com/rebuilding_indexes.asp

try this article:-

http://www.sql-server-performance.com/rebuilding_indexes.asp

First of all I would consider going with sql 2005 & not 2000 as the std edition of 2005 has many more features that std 2000 and you could see...

If its still running now then you have a problem. Try and use query analyser to run your T-sql RESTORE command. That way you can get feedback that the query...

remember the transaction log may grow when indexs are being rebuilt

type encryption into the search bar, there are many articles that will get you started.

stop & restart all your MSDE serivices.

you will also need http://www.dbmaint.com/free_utilities.asp if you install XPSMTP, it works really well, SMTP is a much more reliable than MAPI. If you have an IIS machine on...

install sql service manager, then you can see all the instances you are running on your machine, this will reduce the confusion.

apologises, i would indeed use 2003 windows on nodes, both enterprise edition.

The sql licensing are covered as it will only be a passive server. Windows 2003, i'm presuming you need...

yep thats right. I have done a bit more R&D and think it is possible but a bit tricky.

Why do you think it is not possible?

"if we lived in a fluffy world we would either return the goods or accept the charge"

however thinking big scale, Amazon should be punished by this mistake to make...

Try it!, but there should be no problems as I think all the exe's for trans logging are run in there own enviroment. I think 2003 sp2 has support to...

works fine!!