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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup Device vs File Name

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-03-17 : 08:12:05
Paul writes "Why would I create and use a "Backup Device" versus simply using a "File Name" for each backup.

Is it speed, recovery, parallelism?

The backup window asks for File Name or Backup Device."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-03-17 : 08:11:27
It's really just convenience. Devices are mapped to files anyway, so there's no difference in performance.
Go to Top of Page
   

- Advertisement -