I have a SQL cluster I built about two weeks ago on Windows 2003, now we are
trying to restore a database to the server from a different location (non
cluster) and we are unable, database seems to go but sql manager states the
database is in a still loading state, is there anything I have to do, like
stop the cluster services.

Thanks,
Bob Smith

Hi

Make sure that you select "Leave database oprational..." from the options
tab in the Restore dialogue.

You can re-run the restore, overwriting the DB you tried earlier.

Regards
Mike

"Bob Smith" wrote:

Mike,

Thanks, but this was checked, do I need to break the cluster to do a
restore, I even tried creating new database and doing an import, btw I am not
a very experienced sql admin, I know my way around and can troubleshoot etc,
but I done the restore on a straight sql server non cluster, then I go to the
clustered setup and do the restore and it sits there saying loading and it is
grayed out.

Thanks Again,
Bob Smith


"Bob Smith" wrote: