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 |
|
erico
Starting Member
34 Posts |
 Posted - 2006-10-11 : 12:32:33
|
| I'm new to SQL Server and need to know how to do a backup to external media or at the very least backup to my local C: drive then I can just drag & drop to the media. I'm familure enough with Enterprise Mgr interface that I can right-click on run through the motions but I get an error.ERROR MSG:Cannot open backup device 'DVD Drive'. Device error or device off-line. See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormally.Any help on this is much appreciated.ThanksEric |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-11 : 12:41:29
|
| Backup to a local disk then copy that to dvd.backup databse mydb to disk = 'c:\mydb_20061011_1739.bak'Zipping a backup file is usually very effective.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
erico
Starting Member
34 Posts |
Posted - 2006-10-11 : 12:50:53
|
| So are you saying that I type this in the Start, Run box literally as is but change the mydb to the database name?backup databse mydb to disk = 'c:\mydb_20061011_1739.bak' |
|
|
|
|
|
|
Backing up SQL Server 2005 DB to CD or DVD