SQL 2000 + SAN - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL 2000 + SAN

Author

Topic

kerrycorcoran
Starting Member

38 Posts

Posted - 2009-05-12 : 13:31:58

Windows Server 2000
MS iSCSI Initiator 2.08
Equallogic SAN

Currently my DB's reside on the local C: drive of the server. I want to move the DB's to another drive with more storage.

If I detach/move/attach the DB's to another location on the C: drive, upon opening Enterprise Mananger, the DB's are fine.

If I detach/move/attach the DB's to the S: drive (newly added iSCSI Target), upon opening Enterprise Mananger, the DB's are listed as Suspect.

Any ideas what could cause this? Or what additional steps I should be taking to move these DB's to an iSCSI storage location?

Thanks,
Kerry

kerrycorcoran
Starting Member

38 Posts

Posted - 2009-05-12 : 15:50:12

Issue resolved.
The problem was the MS SQL service was starting prior to the MS iSCSI service; thus the iSCSI target wasn't getting mapped until the SQL server was running.
For infomation on working with service dependencies:
http://support.microsoft.com/kb/193888

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources