All,

Thanks so much for your responses.

Based on these two articles http://support.microsoft.com/default.aspx?scid=kb;en-us;814848 and http://support.microsoft.com/default.aspx?scid=kb;en-us;240240 this is our problem.

To quickly rap them both up; files and folders have two names associated with them a long name a short name.  Short name are applied as applications are installed.  When a backups is preformed the short name is not captured, when backup is restored new short names are applied but not in the same order as when the applications were installed.

The articles resolution to this problem is to reinstall any programs that exhibit this behavior. We really don’t want to do a new install of SQL Server because of the possibility of differences in configuration settings.

I have been able to start SQL Server and SQL Server Agent by changing the short name path for SQL Server to the full path in the following registry locations:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER

 Before Change:

d:\PROGRA~1\MICROS~1\MSSQL\binn\sqlservr.exe

After Change:

 D:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT

 Before Change:

d:\PROGRA~1\MICROS~1\MSSQL\binn\sqlagent.exe

After Change:

D:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.exe

I have some concerns with making these type of changes.

Any assistance you can provide is greatly appreciated!

Shawn