блин.. понимаю что вопрос наглый, но всё же (надеюсь сэкономить время)
в какой последовательности и какие операции надо проводить, чтоб перенести базу с существуещего MS SQL сервера (в сети) на MS SQL Desktop Engine на локальном компе?

пробовал через BACKUP DATABASE - RESTORE DATABASE ругается... говорит

Msg 5105, Level 16, State 2, Server VASILIY, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\distance_Data.MDF' may be incorrect.
Msg 3156, Level 16, State 1, Server VASILIY, Line 1
File 'distance_Data' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\distance_Data.MDF'. Use WITH MOVE to identify a valid
location for the file.
Msg 5105, Level 16, State 2, Server VASILIY, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\distance_Log.LDF' may be incorrect.
Msg 3156, Level 16, State 1, Server VASILIY, Line 1
File 'distance_Log' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\distance_Log.LDF'. Use WITH MOVE to identify a valid location
for the file.
Msg 3013, Level 16, State 1, Server VASILIY, Line 1
RESTORE DATABASE is terminating abnormally.


спасибо!

1> restore filelistonly from disk = 'd:\disbkp'
2> go
LogicalName
PhysicalName
Type
FileGroupName
Size MaxSize
-------------------------------------------------------------------------------
distance_Data
C:\Program Files\Microsoft SQL Server\MSSQL\data\distance_Data.MDF
D
PRIMARY
52166656 35184372080640
distance_Log
C:\Program Files\Microsoft SQL Server\MSSQL\data\distance_Log.LDF
L
NULL
12648448 35184372080640
(2 rows affected)
1> restore database distance from disk = 'd:\disbkp'
2> with move 'distance_Data' to 'd:\disdb\distance_Data.mdf',
3> move 'distance_Log' to 'd:\disdb\distance_Log.ldf'
4> go
Processed 1520 pages for database 'distance', file 'distance_Data' on file 1.
Processed 1 pages for database 'distance', file 'distance_Log' on file 1.
RESTORE DATABASE successfully processed 1521 pages in 4.052 seconds (3.073
MB/sec).