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 |
|
igoro1975
Starting Member
7 Posts |
 Posted - 2002-08-15 : 13:10:20
|
| What's the difference between restore from database and restore from device?Device - from file.Database - the same file.Am I right?"I do not fear computers. I fear lack of them." - Isaac Asimov |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-15 : 13:22:34
|
| They're not the same. Devices can exist on tape, database files cannot. A device is specifically for backups. It can't be queried like a database. And you can't restore from an .MDF file that holds database data for that reason. A device is created in advance to be used for backup operations. You can back up and restore to a standalone file, but you must indicate it using special clauses in the BACKUP and RESTORE commands. Also, backing up to a file does not permit you to take advantage of media sets, and may not allow the ability to restore to a point in time (STOPAT keyword). |
 |
|
|
igoro1975
Starting Member
7 Posts |
Posted - 2002-08-15 : 14:01:45
|
| Thank you."I do not fear computers. I fear lack of them." - Isaac Asimov |
|
|
|
|
|
|
What's the difference?