Hi All,

Well basically I am doing an in place upgrade from SQL Server 2000 to SQL Server 2005 and it appears to freeze when running the msdb_upgrade.sql script.

I have investigated the issue and it appears that I failed to run the sp_delete_backuphistory procedure before running the setup.

OK so my question is this if I cancel the installation at this point what affect will it have on the installation and exactly where will it rollback to and what issues will I face.

Also is there any way to truncate the tables during the intallation process as this will allow the process to finish much faster or is it best just to let it run through.

Thanks in advance