2009-11-25 03:26 AM
I am having the same issue as described in this discussion.
I have a 2005 SQL Failover cluster.
Unfortunately the storage was not configured correctly from the outset.
LUNs were presented to the Windows Hosts via SnapDrive.
In bad practice fashion the System DB's were installed on the same LUN as the User DB's.
We presented another clustered LUN via SnapDrive to house the System DB's
We were unable to move the System DB's using SnapManager For SQL so this was done using SQLCMD's.
The SnapManager For SQL Configuration Wizard now reports on the Database Selection page that all the User DB are 'Invalid/Local'
In the window below the System DB's are showing as being on the new LUN.
All the .mdf & .ldf files for the System DBs have been removed from the old LUN location.
Please can you help ?
2009-11-25 08:25 AM
This looks a slightly unusual scenario. Can you provide me with two pieces of information: -
1. Screen-shot of the SMSQL Config Wizard for the Database Migration portion.
2. The exact listing of the files on the concerned LUNs including the actual location of the LUNs. Please mention whether you are using drive letters or mount points.
I will look into this further once the above information is given.
2009-11-25 09:04 AM
When you moved the system databases did you follow the following steps:
To move a system database data or log file as part of a planned relocation or scheduled maintenance operation, follow these steps. This procedure applies to all system databases except the master and Resource databases.
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path/os_file_name' )
SELECT name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id = DB_ID(N'<database_name>');
2010-02-09 06:10 PM
This error is purely due to incorrect database layout in the storage device. Please refer to the Installation and Admin Guide of SMSQL (Chapter 6) and ensure that no rule is violated. If all that is done and you still get the same error then we'll have to investigate.