Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1432
  • Last Modified:

NOUNLOAD

in B&R, what is NOUNLOAD?

thanks
0
anushahanna
Asked:
anushahanna
  • 4
  • 4
2 Solutions
 
Guy Hengel [angelIII / a3]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]Billing EngineerCommented:
no, only when you do backup to tape.
for any other kind of backups, this option is ignored
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now