Re: drive not visible in the SQL server

Tech-Archive recommends: Fix windows errors by optimizing your registry

You have to make the SQL service dependant on the new drive resource. This will require taking SQL offline when making the change.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Julien" <Julien@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:84B592EF-FD04-447B-8456-25ABE59E6FF1@xxxxxxxxxxxxxxxx
Hi all,

Here is my problem:
I've having trouble to make my second logical drive available for database
under SQL server 2005 (Other words: I cannot move database to my second
database drive because I cannot see it in SQL server 2005)

Config:
- Cluster Acitve/passive
- 2 nodes (Win 2003 server SE SP2)
- 4 drives configured:
* drive 1 for quorum
* drive 2 for fro tempdb
* drive 3 for my database (old) and logs
* drive 4 for my database (where I want to move to)
- SQL server 2005 SP1


This new drive is properly configured (or so I think) in the cluster admin,
as a physical drive part of my SQLserver Data group resource (as my old drive
is) and is showing up active in my resource list.
I can also browse it as normal from Windows

When trying to move the database in SQL server 2005, I can only browse my
current database drive and I cannot see the new one.

Any ideas what am I missing ?

Thanks a lot for your help.

Julien



.

Relevant Pages

  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... so we need frequent copies of the database for testing, ... Which drive for logfile backups? ... Why are you using Enterprise edition of SQL Server if you only have Std ... drives with no Raid. ...
    (microsoft.public.sqlserver.programming)
  • Re: Checkpoint causes need for better IO subsystem?
    ... excellent articles on clustered index selection and its impact on ... clustered index sql kimberly tripp ... Microsoft SQL Server MVP ... the random write capability of the drives comes into play, ...
    (microsoft.public.sqlserver.tools)
  • Re: Adding another server instance to another hard drive?
    ... A disaster recovery plan will help you minimize data loss. ... If your computer crashes and/or you lose your SQL Server drive, ... get lucky with a successful attach of the database files if your database ... > drives to actively store data. ...
    (microsoft.public.sqlserver.server)
  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... so we need frequent copies of the database for testing, ... Andrew J. Kelly SQL MVP ... But by placing the backups on the same drive as the data or logs you risk loosing data if one of the drives crashes since you will loose backups and either the log or data files. ...
    (microsoft.public.sqlserver.programming)
  • Re: New SQL Server 2000 installation
    ... a single IDE drive and 512MB RAM -- and don't have any performance issues. ... The PE1850 only holds two drives, so I'm stuck with a mirrored SCSI ... >> I'm going to be setting up a new SQL server and was hoping to get some ...
    (microsoft.public.sqlserver.setup)