cannot see second drive????  
Author Message
Ant-Knee





PostPosted: Mon Jun 14 09:45:57 CDT 2004 Top

SQL Server >> cannot see second drive????

I am running an SQL database on a win2000 server with SQL 2000 and all updated service packs. I have a database that I would like to move to a second drive on the same server. When I look into the database (properties\database locations) I cannot see the second drive, only the drive that SQL is installed on. The second drive is formatted and data is on it already but I cannot see it when I use the browse button from the above location. How do I see this second drive? Thanks in advance for any help on this
L

SQL Server112  
 
 
rboyd





PostPosted: Mon Jun 14 09:45:57 CDT 2004 Top

SQL Server >> cannot see second drive???? Verify that the account that SQL Server starts under has full control of
the root of the drive. If the local system account is being used then make
sure the SYSTEM acount ahs full control.

Rand
This posting is provided "as is" with no warranties and confers no rights.