Re: Navision backup and SQL error
2003-06-25 13:23:55
>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
|
|
|