For Question1:

No impact will be there

From 2K-BOL:

The SORTED_DATA_REORG clause of CREATE INDEX eliminated the sort performed when a clustered index was created. Replaced by the DROP_EXISTING clause of CREATE...

I could think of the following steps:

1.Remove logshipping on the primary.

2.Restore/Reinstall the secondary.

4.Restore the latest Fullbackups of the logshipped DBs.

3.Reconfigure logshipping.

Regards,

Here, this page has the minimum requirements that are needed for installing different Editions of SQL Server 2005

http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx

🙂

No, I do not think the users can do anything from their end.

What kind of memory issues are you getting? If you see anything in the errorlogs, you might want...

Click on options and increase the connection timeout property and see if that helps.

If you can get some outage to reboot the machine, that would be one option to try.

Otherwise, disable write caching on the drive and defrag it and see if...

[font="Verdana"]

I am not sure about VBScript but, you can use some OS commands to get this done.

I created a job in SQL Server for this and it works fine....