I am running an SQL database on a win2000 server with SQL 2000 and all updat
ed service packs. I have a database that I would like to move to a second dr
ive on the same server. When I look into the database (properties\database l
ocations) I cannot see the
second drive, only the drive that SQL is installed on. The second drive is f
ormatted 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 a
dvance for any help on thisVerify 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment