Backup or Restore from Enterprise Manager.

We've added a new disk to our server.
When we click through the SQL Server Backup, to select
the "Backup Device Location", the new drive is not
available. The only drive that is available is the one
that existed when SQL was installed.
The same is true for restores.
Any ideas?
TIA,
Sean.
Hi,
Execute the below command from Query Analyzer;
xp_fixeddrives
If you are not able to see the new drive, Check for the existence of that
drive from Windows Explorer, if not contact your system administrator.
Thanks
Hari
MCDBA
"Sean Irving" <sbirving@.hotmail.com> wrote in message
news:178ae01c41dfe$8f99da60$a601280a@.phx.gbl...
> We've added a new disk to our server.
> When we click through the SQL Server Backup, to select
> the "Backup Device Location", the new drive is not
> available. The only drive that is available is the one
> that existed when SQL was installed.
> The same is true for restores.
> Any ideas?
> TIA,
> Sean.
>
|||If SQL Server is clustered, you have to add a dependency (SQL Server has to
depend on the disk). Also make sure you've restarted Enterprise Manager
since the disk was added, it may not have refreshed with the new
information.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.