Thanks for everyones help. After much frustration I ran the client network utility. It had only TCP/IP network library . After adding multiprotocol and named pipes with the same parameters...

Keep in mind I'm a total novice here....I assume you're talking about the files structure in the data directory? If so then I only have the MTSDE.mdf and MTSDE_log.ldf files.

I...

A little more info:

The first backup I tried by telling it to backup from device and pointed to the backup. I tried changing that to point to a file on...

Ok - thanks for all your help. I now have all my databases back and running and have been able to recreate the MTSDE database for the Magic Enterprise database....

I'm using QA and have tried it 2 ways

1. Started SQL normally and used this

Use master

go

sp_detach_db 'MTSDE' (or 'pubs' or 'Northwnd' - all of them fail the same way)

go

2....

I've made some progress. I got the master restored using Query analyzer. I then did a system table update as follows:

USE master

go

UPDATE sysdatabases SET filename='d:\mssqlt\data\tempdb.mdf' WHERE name='tempdb'

go

ALTER DATABASE tempdb MODIFY...