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.
I didn't quite follow what your setup is so I kept quiet, but what you describe is close to what we do and I would answer yes. The only gotcha I can think of is whether any non-logged operations happen,
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…