Hi Don

We're having an insurance company backing up a lot of SQL servers. The larges is about 500GB.

The TDP can give you differential backups. This means you don't have to backup the whole database, only the changes, but with a difference comparing to the normal TSM incremental. The differential backup makes a backup thats contains all of the data thats has changed since the last full backup(which differences from incremental, which is, normally, the changes since the last incremental). But, if you do incremental monday, tuesday, wednesday, thursday, you can do the full on friday, and save a lot of time.

The TDP for MSSQL 1.1.2 could do incremental backups(as described above), but I don't know why Tivoli has changed this procedure to differential.

And, when restoring the database server, using TDP is a lot faster rather than using the dump procedure.

Using the dump procedure, you first have to restore the dumpfile, and then you have to import the file to SQL server.

When using the TDP, you only have a restore procedure. This save a lot of time, about 50%.

Best Regards

Daniel Sparrman

-----------------------------------
Daniel Sparrman
Exist i Stockholm AB
Bergkällavägen 31D
192 79 SOLLENTUNA
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51

 
Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2002-01-15 12:36 EST
Please respond to "ADSM: Dist Stor Manager"

To: ADSM-L AT VM.MARIST DOT EDU
cc:
bcc:
Subject: Re: ADSM Questions

Hi Don:

You want to get the TDP for MS-SQL agent to do direct backup and restore of MS-SQL tables, then exclude the DB from the normal file backups, and discontinue the export of the tables to flat files for backing up by TSM.

>>> Donald.Tipton AT DAS.STATE.OH DOT US 01/15/02 12:13PM >>>
Hello:
    I'm new to ADSM and we are using it to backup a Windows 2000 server
that is running SQL Server 2000.  I had a few questions I was hoping
someone could help me with.

1.  ADSM only backs up files that are not in use or "open"?
2. Do SQL Server data files and transaction log files appear as "open" to
ADSM  when the instance is started?
3. Is the TDP product just for scheduling, keeping rack of, easy of use
etc. or does it have some other functionality as far as SQL Server backups
are concerned?  Is it a make or break product for backing up SQL Server
data and log files using ADSM?

We do have regular backups scheduled within the SQL Server Enterprise
manager and these backup files are backed up by ADSM, I'm just curious if
ADSM can give us another layer of recoverability by actually backing up the
data files themselves.

Thanks,
Don Tipton