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 |
|
joeypham
Starting Member
2 Posts |
 Posted - 2006-09-10 : 12:50:15
|
| Hi guys, I've tried to back a database from a server on the net ie: discountasp.net by using Microsoft SQL 2005 Express management tool.After all the set up:(1) the part "Destination", in the "Disk" radio button was cheked, the path for the backup file shows like: D:\MSSQL.1\MSSQL\Backup\myDatabase.back; As I understand D:\ is the CD drive(?), so I put a CDisc in the drive, and kept going with the process. The Process went very well and inform that the Database has been fully backed up. But I never have found the "saved" or "backed up" that I backed up. Can anyone show me where this backup Database in that D:\ drive, and where is that D:\ drive anyway?(2) In that "destination" part, if I clicked "add", and then typed in the path address part like: C:\....\mybackupDatabase.bak for example, the the tool gave me the error: ... not set to an instance ...; I counldn't even select the Browse to browse to the directory that I wanted to back up the Database.Please help me for this.Regards.Joey |
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-09-10 : 16:02:27
|
| Backup is performed on the server, not the local machine, so the D: you are seeing is not your CD drive but a local harddrive on the server. Only way to make a backup to an other machine is if you can map a drive on the server to that machine, or you will have to access the backup file by other means, like using FTP.-- The Heisenberg uncertainty principle also applies when debugging |
 |
|
|
|
|
|
|
|
Microsoft SQL 2005 express Management tool-errors