Very Computer

by **Chris Beardsle** » Fri, 15 Mar 2002 00:43:55

In reading a SQL Admin book, I noticed they talk about creating Backup
devices (permenant) then in a notes section they mention "temporary backup
devices".

We use Temporary Backup devices exclusively for our DB maintenance plans and
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

by **Sue Hoegemeie** » Fri, 15 Mar 2002 22:34:18

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.

--Sue

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 backup
>devices".

>We use Temporary Backup devices exclusively for our DB maintenance plans and
>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

by **Reinaldo Kibel (** » Wed, 27 Mar 2002 05:17:40

Chris,

That is correct. Additionally you can check the Books Online description I
included links bellow.
--- Backup Devices
http://search.microsoft.com/gomsuri.asp?n=1&c=rp_Results&target=http:....
microsoft.com/library/en-us/adminsql/ad_bkprst_6hmb.asp

Reinaldo Kibel
Microsoft? Corp. - SQL Server Support Engineer

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
http://www.microsoft.com/security.
--------------------

| 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.
|
| --Sue
|
| 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
backup
| >devices".
| >
| >We use Temporary Backup devices exclusively for our DB maintenance plans
and
| >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