Active IQ Unified Manager Discussions

database move failed

mrgoodman
4,063 Views

attempted to move Windows dfm 3.8.1 database from a local drive to an attached LUN using dfm datastore setup Z:\datbase\data.

Note: NOT attempting to configure failover or standby, just want the database and log on the LUN

Have searched through manual and KB articles and bug reports.

Command responses  indicated success.

Issued  dfm service start sql which failed.

Had to manually set the  dblogdir - it was incorrect

Tried again with failure.

dfm service start sql:

Error: note> this machine could be configured for failover or standby. sql services will not be started on a stand by machine.

Error: Timed out while starting sql

Serivce did not reach started state due to timeout

get current status with dfm service list sql

check the system event log for more detail

Error: couldnot start service sql

dfm service list sql returns:

sql: not started

Event Viewer:

The description for Event ID ( 1 ) in Source ( SQLANY 10.0 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: DFMSybase, Cannot access "Z:\database\data\monitordb.db": file does not exist.

dfm database get reports both log and database with correct path

Both the database and the tranaction log are in new destination

Attrib command returns same for both original and retstored files.

dblog z:\database\data\monitordb.log  returns correct location and size.

Perfdata, plugins and reports are also copied to new destination

Cannot determine if these are in correct path, database unavailable is returned.

This command didn't actually migrate, the data, it only copied it. A copy of the original database, database log and the other subdir's still exist in the default directory.

Renamed orginal subdirectories, but no help.

other dfm commands report : Error: The datafabric manager is temporarily unavailable, error code is -100.

Not sure what to do next.  Aplogize for lenght. Any assistance would be appreciated.

4 REPLIES 4

adaikkap
4,063 Views

What is the output of the following command?

dfm backup diag.

Regards

adai

mrgoodman
4,063 Views

Error: the datafabric manager database is temporarily unavailable; error code is -100

Note: SQL will not start.

Any assistance would be appreciated. 

prasads
4,063 Views

>Cannot access "Z:\database\data\monitordb.db": file  does not exist.

Are you sure the files copied are still there in target (z:\)  location with full access?

Can you re-try the operations again.

1. dfm datastore setup -n <install-dir>

#dfm datastore setup -n "c:\Program Files\NetApp\DataFabric  Manager\DFM"

2. dfm datastore setup -f <target-directory>

#dfm datastore setup -f Z:\database

But if you are interested in moving only the DB &  DBLOG files, you can replace step2 with the below command.

2. dfm datastore setup -f -d Z:\database -l Z:\database

mrgoodman
4,063 Views

this worked. thanks

Public