Basically you need to troubleshoot by starting wide and narrowing in to what the problem may be.

Start with looking the sql server error logs for such issues as space running...

As you said the select statement to declare the cursor works, the issue may not be with the cursor, rather with the back up statement. ie. it could be failing...