Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ejko
Starting Member
2 Posts |
 Posted - 2005-06-25 : 20:25:12
|
| Hello,I created an .BAK file of a database on a remote MS-SQL server and copied it via ftp to my disk. I created the same database on my local MSDE server and now need to fill the database with data. I tried restoring the database, but the backup file won't show in the list of backups and I cannot browse the disk. I also tried importing the data, but couldnot find proper datasource which would allow me to use .BAK file. How can I solve this problem?Any hints will be greatly appreciated. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-06-25 : 20:40:15
|
| >> I cannot browse the diskIf You are trying to restore the database using EM (Enterprise Manager)Choose "From Device" radiobutton, -> "Select Device" button -> "Add" button -> File name -> ...You really should read up on the BACKUP and RESTORE commands in BOL.rockmoose |
 |
|
|
Ejko
Starting Member
2 Posts |
Posted - 2005-06-26 : 02:22:26
|
| Yeah that was it. Sorry for my newbiness. :) |
|
|
|
|
|
|
Replicating a database on another computer