Re: Diff between Logical Backup and Full Backup

From: BP Margolin (
Date: 02/04/03

From: "BP Margolin" <>
Date: Mon, 3 Feb 2003 23:09:49 -0500

John Paul,

>From the SQL Server 2000 Books Online, section "Backup Devices"

"A logical backup device is an alias, or common name, used to identify the
physical backup device. The logical device name is stored permanently in the
system tables within SQL Server. The advantage of using a logical backup
device is that it can be simpler to refer to than a physical device name.
For example, a logical device name could be Accounting_Backup, but the
physical device would be C:\Backups\Accounting\Full.bak."

>From where are you getting the terminology "logical backup"?

BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"abcd" <> wrote in message
> Hi,
> What is the exact difference between logical backup
> and full backup ?
> Is there any advantage of logical backup ? Whether this funda is same for
> all RDBMS including oracle/DB2 ?
> John Paul,