I never tested that far out. I know the default instance will be SQL 7 , but this may help a little better on what to do to remove SQL...

You may have orphaned the users and for some reason are able to see them. Try sp_change_users_login with the auto_fix option to see if will correct, may be just that...

1) It will install over the folder of the exiting installation. However it may leave some SQL 7 related files behind that will never be used.

2) They will upgrade fine,...

Did you check the Event Viewer logs. Many messages have additional details that can be found here. May not but always check there.

Have you recently Service Packed the server. I remember running into this once before and I beleive it had to do with a problem of the Client and the Service...

Also, try DBCC CHECKDB with the REPAIR_FAST option if the first run reports errors, it should be able to fix.

If that does not correct can you please post the entire...

DOuble check but I believe there is an SP for that built into msdb. No database online here right now so I cannot double check.

Another option is if you use SPs to control flow then place code in there on in you app to write this info to the database. But triggers guarantee an...

You really are only looking at the execution plan for processes that can hurt performance such as Table Scans. The other information is more statistical.

If their database is live then a differential will not work. Any you cannot backup their database then restore it with no recovery and apply a diff as the internal...

I am not sure that BackupExec actually truncates the log files. In 2000 I usually run BACKUP LOG dbanme WITH TURNCATE_ONLY, then do a Full backup with BACKUP DATABASE then...

Check the NT Event Viewer logs and SQL Server logs. There is usually a bit more detail in EV logs when backup issues occur.

Have you tried running the DTS package by hand to verify it is not the problem instead? It can be caused by various reasons and sometimes running by hand may...

Check the SQL Server error log as error 945 states. This should give you a better idea as to why. Usually it is the file cannot be located or access...

Please do not cross post. Duplicate, see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8444&FORUM_ID=9&CAT_ID=1&Topic_Title=HELP%21++Need+to+use+trans+log+for+restore%2E&Forum_Title=General