I have a backup issue which I want to try an resolve.
Basically we have a 'log shipped' copy of our SQL Servers off site which are approximately 15mins behind the Production (On Site) Servers. We also backup a file backup (.bak file) of our database off site directly to tape and this takes about 24hrs+.
Apparentely our company requires a 'warm copy' and a file copy off site, of our production server.
So what I would like to do is try and backup the 'log shipped' database straight to tape - if it is possible?
If I can do this then on a local LAN our backup takes about 4 hrs to tape.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.