Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving (or copying) a database from one server to anothe
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00706195
Message ID:
00706619
Views:
18
>>The problem: I performed the backup of the source database from the enterprise manager of the target server (machine). The program said that backup would be made to c:\MSSQL7\backup\name, but it was refering to c: of source machine, I guess because it was the source server talking through Enterprise Manager.
>>
>>I the tried manually copying the file to c:\MSSQL7\Backup of the target machine and performing a restore from device indicating the copied file as the device, but couldn't fool the system.
>>
>>Suggestions?
>>
>>Thanks again.
>>
>>Alex
>>
>
>Hi Alex,
>In Options Tab (in Restore Database dialog) check the Restore over existing database option (and also check files names)

Thants for the help, Venelina. Finally got it to workconsistently.

Alex
Previous
Reply
Map
View

Click here to load this message in the networking platform