All

please find part 3 here[/url]

please supply more info on the server setups such as windows os version, number of cluster nodes and any NIC assignments

it's probably easier to stop the log shipping and remove the secondary database. Sort out the disk space and file locations and then re initialise the secondary database

what events do you see in the application event log when trying to start the agent service normally

mazzz

i'm not clear, are you adding a node to an existing clustered instance or creating a new clustered instance?

you do not need to specifically restore a transaction log,...

jprovines

please execute the following against the primary server

use master

exec sp_help_log_shipping_primary_database @database = 'yourdb'

and this against the secondary

use master

exec sp_help_log_shipping_secondary_database @secondary_database = 'yourdb'

Post the results for both these!

Thank you all for your feedback. I created this article as to me it seems the DBA is always an afterthought in most organisations.

"oh he\she only looks after the...

thank you, i appreciate your feedback

Thank you, combine all 3 parts and you have all you need to create a cluster testbed from scratch

please execute the following against your log shipped secondary database and post back the results

exec sp_help_log_shipping_secondary_database @secondary_database = 'secondary_database'

Execute the script below against your production database server under the context of the database for which you wish to export users and the resulting script output will form the...

Ninja's_RGR'us (8/6/2011)

Perry Whittle (8/6/2011)

You...

You should be looking...

Are you using MS iSCSI initiator?

If so do not use teaming for these NICs use the initiator policies for fail over or load balancing