That is correct. Additionally you can check the Books Online description I
included links bellow.
--- Backup Devices
Microsoft? Corp. - SQL Server Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2002 Microsoft Corporation. All rights
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
| Subject: Re: Understanding Backup Devices and Temporary Bkp devices
| Date: Thu, 14 Mar 2002 06:34:18 -0700
| One of the main advantages of using logical devices is that
| you can refer to the backup/restore device using the logical
| name. I've never really read of any other advantages.
| On Wed, 13 Mar 2002 10:43:55 -0500, "Chris Beardsley"
| >In reading a SQL Admin book, I noticed they talk about creating Backup
| >devices (permenant) then in a notes section they mention "temporary
| >We use Temporary Backup devices exclusively for our DB maintenance plans
| >for our occasional adhoc backups.
| >What are the reprocussions of this approach? Why is it better (safer?) to
| >create the backup device first?
| >Any insight or pointers to more indepth info will be appreciated!
| >Chris B