1

Topic: Recovery of basis from a tape

Kind time of days. I am the developer 1. There is a desire permanently to have the most actual copy of basis for testing, at what not under the schedule of the agent, and manually - during the arbitrary moment of time. As I it see - simply enough to write request for recovery of a copy from necessary  (file/device). The manager of a DB with such approach does not agree - speaks,  are stored on tapes with the API, for writing of such script/inquiry a lot of time leaves, all it very difficult and demands learning. In my opinion strange enough argument - the tape for certain has some driver allowing server MSSQL to "talk" to the device in its language... Besides, according to the manager - before  were fulfilled by it interactive sequence of some actions - of what I do an output that SQL is able to communicate with a tape, and it is enough to pack sequence of actions of the manager into some algorithm on T-SQL. . Explain please, whether really specified reason takes place to be and carries itself the big expenditures of labor?

2

Re: Recovery of basis from a tape

AlphaSpec;
It is possible to be recovered by hands through the client console (at TSM it is). A script strongly hardly. I suppose absolutely in any way.

3

Re: Recovery of basis from a tape

It is possible to change the reservation order: at first to reserve on a disk, then to copy on a tape. The last disk copy will be accessible to you.

4

Re: Recovery of basis from a tape

Mr. X wrote:

AlphaSpec;
It is possible to be recovered by hands through the client console (at TSM it is). A script strongly hardly. I suppose absolutely in any way.

the HARDWARE about TSM did not mention, but for it it is possible and  GUI and a script, but the rights be required, most likely with them there will be a problem

5

Re: Recovery of basis from a tape

The registrar;
With access rights a question solved. How much difficult for the manager of a DB to write such request for recovery of specific basis from , stored on a tape? The problem designated by the manager of a DB - is not a problem as a matter of fact?

6

Re: Recovery of basis from a tape

All depends from:
1) That for library is used (how many drives, holders, etc.), in the elementary cases, are put driver LTFS and a tape sees as a normal disk and therefrom it is possible to pull archives through a normal explorer
2) Depends on a software of reserve copying TSM\HPE Data Prjtector\EMC Networker and others, at all the are possibilities and interaction interfaces

7

Re: Recovery of basis from a tape

wrote:

it is how much difficult to write for the manager of a DB such request for recovery of specific basis from , stored on a tape? The problem designated by the manager of a DB - is not a problem as a matter of fact?

https://docs.microsoft.com/en-us/sql/t- … ansact-sql
RESTORE DATABASE {database_name | @database_name_var}
[FROM <backup_device> [... n]]
[WITH
{
<backup_device>:: = Specifies a logical or physical backup device to use for the backup operation, as follows:
{DISK | TAPE} = {' physical_backup_device_name ' | @physical_backup_device_name_var}
Allows backups to be restored from the named disk or tape device.
The device types of disk and tape should be specified with the actual name (for example, complete path and file name) of the device: DISK = ' Z:\SQLServerBackups\AdventureWorks.bak ' or TAPE = ' \. \TAPE0'
https://docs.microsoft.com/en-us/sql/re … sql-server

8

Re: Recovery of basis from a tape

AlphaSpec wrote:

the Manager of a DB with such approach does not agree - speaks,  are stored on tapes with the API, for writing of such script/inquiry a lot of time leaves, all it very difficult and demands learning.

As it you it is qualified sent!
I take off a hat!
[spoiler in secret]
The mechanism  / restitutions from a tape is built already in a SQL Server.
Simply enough to connect an appropriate drive.
After that at you the option "Tape" as source of archives is activated.
[/spoiler]

9

Re: Recovery of basis from a tape

AlphaSpec wrote:

the registrar;
With access rights a question solved. How much difficult for the manager of a DB to write such request for recovery of specific basis from , stored on a tape? The problem designated by the manager of a DB - is not a problem as a matter of fact?

Depends on a software which you it is used, for example for mentioned TSM one line in the command file (.cmd, instead of request TSQL) that that of type such (recovery last (active) ):

@echo off
@SETLOCAL
SET DV_DIR_TSM=D:\RestoreSQL
SET DV_DIR_TDPSql=C:\Program Files\Tivoli\TSM\TDPSql
SET DV_SQL=SQLserver\instance
SET DV_DB_SOURCE=1c_001
SET DV_DB_LogicalName_MDF=1c_001
SET DV_DB_LogicalName_LDF=1c_001_log
SET DV_DB_DESTINATION_DIR=D:\SQL
"%DV_DIR_TDPSql %\TDPSQLC" Restore %DV_DB_SOURCE % Full/BACKUPDESTination=TSM/BACKUPMETHod=LEGACY/INTO = % DV_DB_SOURCE OF % _ test/LOGFile = % DV_DIR_TSM %\tdpsql-restore.log/RELocate = % DV_DB_LogicalName_MDF OF %/TO = % DV_DB_DESTINATION_DIR OF % \% DV_DB_SOURCE OF % _ test.mdf/RELocate = % DV_DB_LogicalName_LDF OF %/TO = % DV_DB_DESTINATION_DIR OF % \% DV_DB_SOURCE OF % _ test_log.ldf/RECOVery=Yes/REPlace/CONFIGfile = "% DV_DIR_TDPSql %\tdpsqlA.cfg"/TSMOPTFile = "% DV_DIR_TDPSql %\dsmA.opt"
REM use [1C_001_test]
REM alter user [1c-user] with login = [1c-user]
@ENDLOCAL