Logshipping help

As part of my effort to create my own log shipping method, i'm reading
the
documentation people have suggested here. I'm not familiar with some
concepts, the following in particular. From the website
(http://www.sql-server-performance.c...og_shipping.asp
I do have a backup device called DEV_device and the complete path is
D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\QMISDEV
The article contains the statement below which I am not sure I
completely understand...
RESTORE LOG database_name
FROM DISK = 'g:\mssql7\backup\log\database_name\data
base_name_log_backup_dev
ice.bak'
The device name in the Authors scenario is
database_name_log_backup_device
My understanding is that a device encompasses the whole path not a
subset of the path(like above).Tested this with little success and my
hope is that there is some one out here with a better understanding
than myself to help out
TIA
TYTY,
The two flavors of BACKUP/RESTORE concerning how to address your file/tape a
re:
BACKUP...
FROM DISK = 'C:\...'
BACKUP...
FROM logical_device_name
In the first example, you address the physical file. No backup devices are n
eeded.
A backup device is like a pointer to a physical file. These are the ones you
see in the backup
folder in Enterprise Manager. If you want to address the file using a backup
device, use the second
alternative.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tyler Smith Watu" <watuni2000@.yahoo.co.nz> wrote in message
news:2f3438a4.0410120431.386cd44f@.posting.google.com...
> As part of my effort to create my own log shipping method, i'm reading
> the
> documentation people have suggested here. I'm not familiar with some
> concepts, the following in particular. From the website
> (http://www.sql-server-performance.c...og_shipping.asp
> I do have a backup device called DEV_device and the complete path is
> D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\QMISDEV
>
> The article contains the statement below which I am not sure I
> completely understand...
> RESTORE LOG database_name
> FROM DISK = 'g:\mssql7\backup\log\database_name\data
base_name_log_backup_d
evice.bak'
> The device name in the Authors scenario is
> database_name_log_backup_device
>
> My understanding is that a device encompasses the whole path not a
> subset of the path(like above).Tested this with little success and my
> hope is that there is some one out here with a better understanding
> than myself to help out
>
> TIA
> TY