ADSM-L

Re: Navision backup and SQL error

2003-06-25 13:23:55
Subject: Re: Navision backup and SQL error
From: Chris Murphy <cmurphy AT IDL.STATE.ID DOT US>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 25 Jun 2003 11:24:30 -0600
>I'm pretty sure it's the one with SQL option...being that SQL runs seems to
be running on all the same
>servers as navision. It's SQL server developer edition version 8.00.
regards, Martin

If you are using the SQL option, then you have a couple options.  Basically,
since SQL is really handling the backups, not Navision, you back it up as
you would any other SQL database.  The Navision software need not be
involved at all.  You can use the TDP for SQL or use SQL's built-in backup
utilities.  We actually use the built-in one to dump the database to a file
on a separate disk array.  Then TSM backs up that "file" as a flat file
(which we have bound to a special MC in TSM).  To restore, simply restore
the file from TSM, and then run the restore process in SQL and point it to
the file.  We have done several restores this way; it has worked flawlessly
for us and actually avoids the TDP altogether.

HTH!

Chris

<Prev in Thread] Current Thread [Next in Thread>