You can set the tape size limit in DPM by adding a registry key. Here is the procedure.
Add a registry DWORD key called TapeSize in the following location:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Data Protection Manager\Agent
Enter the value in MBs.
This will be the new size limit for your tape drive. When media reaches this limit, you will the "End of tape reached" message.