Different backup

Hello,
What is the difference between this two kind of backup
Thisone I set up a file
BACKUP DATABASE [Pubs] TO DISK = N'E:\MSSQL\BACKUP\pubsbackup' WITH
NOINIT , NOUNLOAD , NAME = N'pubs backup', NOSKIP , STATS = 10,
NOFORMAT
This one I created a backupdevice
BACKUP DATABASE [pubs] TO [PUBS] WITH NOINIT , NOUNLOAD , NAME = N'pubs backup', NOSKIP , STATS = 10, NOFORMAT
Is there any difference between this two?
and concerning Log backup Could someone help me on that?
InaThe first command addresses the file directly, the other indirectly, though a backup device (see
sp_addumpdevice).
As for log backup, see Books Online, BACKUP LOG. Also, read about the more descriptive chapters
regarding backup and restore in Books Online. If you post which version you are using, we can give
specific pointers about the relevant chapters in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1146589634.977308.192110@.j73g2000cwa.googlegroups.com...
> Hello,
> What is the difference between this two kind of backup
> Thisone I set up a file
> BACKUP DATABASE [Pubs] TO DISK = N'E:\MSSQL\BACKUP\pubsbackup' WITH
> NOINIT , NOUNLOAD , NAME = N'pubs backup', NOSKIP , STATS = 10,
> NOFORMAT
>
> This one I created a backupdevice
> BACKUP DATABASE [pubs] TO [PUBS] WITH NOINIT , NOUNLOAD , NAME => N'pubs backup', NOSKIP , STATS = 10, NOFORMAT
> Is there any difference between this two?
> and concerning Log backup Could someone help me on that?
> Ina
>|||Thank you a lot for this tips.
As you said the both does the same thing, why do I need for the first
one create a device in the backup option of enterprise manager?
With no doubt I am going to read this tips online, today I need to
restore the database and I am little nervous about that. It is my first
time and I do not know exactly how it works. My log backup and data
backup succeed, so I hope everything going to be alright.
Ina|||> As you said the both does the same thing, why do I need for the first
> one create a device in the backup option of enterprise manager?
This dialog uses sp_addumpdevice to create the backup device. It is a matter of taste whether you
want to address the backup file directly through its file name or indirectly using a backup device
which in turn has the physical file name.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1146636294.125437.29170@.i40g2000cwc.googlegroups.com...
> Thank you a lot for this tips.
> As you said the both does the same thing, why do I need for the first
> one create a device in the backup option of enterprise manager?
> With no doubt I am going to read this tips online, today I need to
> restore the database and I am little nervous about that. It is my first
> time and I do not know exactly how it works. My log backup and data
> backup succeed, so I hope everything going to be alright.
> Ina
>|||thanks :D
Ina