yes odd and quite annoying.

I am going to wipe the server and start again as the best way out of this.

shame it allowed me to install shareddir and sharewowdir as...

Mazz,

make sure you can apply SP1 before going any further.

I managed to get it to install but made the mistake of specifying the same changed location for the directories (thru...

include executions of the sqlcmd utility in the .bat file

sqlcmd is a command line utility to run SQL statements. see BOL.

Shrink, backup log, apply log through log shipping would have worked as well.

If you ran out of space on the secondary but not the primary sounds like they are not sized the same, they really should be.

For what its worth a shrink...

I find users tend to phone up and alert us when a database server is down............:-)

Seriously if you need this box to be Highly available perhaps you need to look...

right click database

tasks

export data

at the end choose to save it as a SSIS package

then you can schedule that package via SQLAgent

Is this not the way you did it manually in...

More questions than answers I am afraid...........

SQL installs some components to the C drive so what is installed on the other server? Is there an identically installed instance of SQL...

its a checkbox in the restore job tab of the logshipping wizard.

If you use the copy table wizard you can save the process as a scheduled SQLAgent job.

you (or anyone else) cannot be connected to the database at the same time as a restore is happening.

you will have to amend the restore job run times to outside...

Its a fundamental principal of clusters that the drives are only visible to the active node so yes that sounds correct.

If you were to failover the cluster resources you would...

There is no way you are going to be able to restore a non-SQL database into a SQL database.

You will have to use logical data transfers rather than physical, hence...

some quick googling highlights this:

http://support.microsoft.com/kb/305977/en-gb

and anyway I have read many times especially on this site that table variables ARE written to tempdb (if not enough memory available). They are also...

nope