Database on USB drive | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database on USB drive

Can I create a new database on a attached USB drive? I can do that on SQL 2000 but I hit error in SQL2005 Express. The error message as below: CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
CREATE FILE encountered operating system error 5(error not found) while attempting to open or create the physical file ‘f: est.mdf’. (Microsoft SQL Server, Error: 1802)
The error 5 is an "access denied" error.
I tried this on SQL Server standard and it works. —————————————-
http://dineshasanka.blogspot.com/
]]>