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
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.
>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