Are you upgrading to SQL 2005? There is an upgrade advisor you can run to help with this.
The database size is large, TBs of data, so I'm not sure that's an issue. Errors can occur at any size. Books online for 7.0 should have a document with this data, search for "maximum capacity"