NOUNLOAD

in B&R, what is NOUNLOAD?

thanks
LVL 6
anushahannaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
http://msdn.microsoft.com/en-us/library/aa225964%28SQL.80%29.aspx
NOUNLOAD

Specifies the tape is not unloaded automatically from the tape drive after a backup. NOUNLOAD remains set until UNLOAD is specified. This option is used only for tape devices.

Open in new window

0
 
anushahannaAuthor Commented:
for disk/device/backupset also, this is automatically scripted out- it is totally not needed in this context, right?
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
no, only when you do backup to tape.
for any other kind of backups, this option is ignored
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
anushahannaAuthor Commented:
is this cleaned up in SQL 2008? (automatically scripting it for disk/device)?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I don't understand that question?
0
 
anushahannaAuthor Commented:
when you script the BACKUP, in SQL 2005, even if it is device/disk, it still puts the above keyword. Does it do the same in SQL 2008?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I don't know, as I do not have a sql 2008 here.
anyhow, as I said, it's not important, as it will be ignored for a non-tape backup/restore
0
 
anushahannaAuthor Commented:
Thanks.
0
All Courses

From novice to tech pro — start learning today.