TimeFinder on MSSQL a possibility?

Let’s face it, if it’s Oracle, DB2, or anything along those lines, I can snap a copy and back it up with my eyes closed.

MSSQL, being a pretend database, has me stumped.  I’m so used to archive logs that I’m not even sure how to use TF/Snap to back up the database.

This is my understanding.  MSSQL doesn’t do “Archive Logging” in the traditional sense.

In a “REAL” database system the process is as follows:

1.  You put the database into “Hot Backup” mode.  In Oracle this quiesces the data files and writes all changes to the transaction log.  (When you take the database out of backup mode, the transactions in the log are then played into the database)

2.  When the above is complete, you can issue a command in one form or another to switch out the last transaction log, which closes one file and opens the next one, and then back up the database files along with the closed transaction log files via whatever file level backup process you have in place, whether it be TimeFinder or just having NetBackup pull the files from that server.

At Disney we did just that, with DB2, and moved in the neighborhood of 250+ Terabytes to tape every night.

At a number of other sites I’ve done the exact same process with Oracle.

Enter MSSQL, a Playschool excuse for an RDBMS, and I’m stumped.  See – the problem is there is never more than one “database.LDF” file for logging.  How am I supposed to quiesce writes to a logfile when it never closes it?

Then add that to the process for rolling transaction log backups forward in MSSQL is dependent on the idea that you used the MS Backup process to back it up.  It seems to be completely unaware of file level backups of the database.

I’m at a loss here – any ideas?

2 comments

    • on December 5, 2006 at 7:28 pm
    • Reply

    You probably want the TF/SIM (TimeFinder/SQL Integration Module).. it falls under the EMC product called “EMC TimeFinder/Integration Modules”. I’m not sure how the licensing works from a sales perspective, but TF/SIM, TF/EIM (Exchange), and SIU (Symmetrix Integration Utilities — useful CLI utils for Symm on Windows). I haven’t worked with TF/SIM.. but I’ve done a lot of work with TF/EIM and SIU.

    • Jesse on December 7, 2006 at 1:12 am
      Author
    • Reply

    We bought it – I haven’t really had a chance to look at it yet, since we’ve only been playing with the Clariion for our production (I.E. Storage “Light”) I’ve not had much call to read the manual.

    It’s in my laptop case now, if I can get off the 13 hour work days I’ll read it.

Leave a Reply

Your email address will not be published.