I'm setting up a new SQL 2005 server to migrate all of our SQL 2000 databases to.
I would like to have the databases and transactions logs on separate drives. I changed the default installation path for the databases during installation to the d:\program files..... directory.
I would like to have all the transaction logs go to the c drive. I created a test db and used the "alter database ...move file" command to move the transaction log to the c drive. It said that it competed succesfully. However,when I restarted SQL server, the file was not moved and I can no longer access the database. I get a "access denied errror". I would like to get this resolved before I start moving the production databases over to the new server.