Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-01 : 09:19:32
|
| OBVIOUS writes "is there an sql query that i can write without switching off the machine inorder to eject a tape after hardware failure to eject the tape.thank you" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-10-01 : 11:08:03
|
| Found this in BOL.........UnloadTapeAfter PropertyThe UnloadTapeAfter property controls tape media handling on completion of a backup or restore operation.Applies ToBackup Object Restore Object Syntaxobject.UnloadTapeAfter [= value]PartsobjectExpression that evaluates to an object in the Applies To listvalueTRUE or FALSEData TypeBooleanModifiableRead/writePrototype (C/C++)HRESULT GetUnloadTapeAfter(LPBOOL pRetVal);HRESULT SetUnloadTapeAfter(BOOL NewValue);RemarksIf TRUE, the tape media in the tape device(s) is rewound and unloaded when the operation completes.If FALSE (default), no attempt is made to rewind and unload the tape media.===========Paul |
 |
|
|
|
|
|
backup