Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-12 : 07:15:17
|
| Jason Fuehner writes "Hi...I read the article you have posted explaining how to store databases on an external server/NAS device and am having some difficulties I was hoping someone could clear up...In the article it explains to turn trace code 1807 on to be able to create/store a db to a unc path... However, when I run the following through query analyzer... DBCC TRACEON (1807) CREATE DATABASE CMS ON ( NAME = CMS_Data, FILENAME = '\\stl-filesvr01\sql server\data\CMS_Data.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ) LOG ON ( NAME = 'CMS_Log', FILENAME = '\\stl-filesvr01\sql server\data\CMS_Log.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB ) I get the following error... DBCC execution completed. If DBCC printed error messages, contact your system administrator. Server: Msg 5105, Level 16, State 2, Line 3 Device activation error. The physical file name '\\stl-filesvr01\sql server\data\CMS_Data.mdf' may be incorrect. Server: Msg 1802, Level 16, State 1, Line 3 CREATE DATABASE failed. Some file names listed could not be created. Check previous errors. Any help would be great on why this is occurring..!" |
|
|
dn014030
Starting Member
3 Posts |
Posted - 2003-02-12 : 17:16:20
|
| First, the NT account which was used to start up SQLServer has to be an domain account and also must have full permission the location you want to create the data file. Second, from query anayzer, run: xp_cmdshell 'dir \\stl-filesvr01\sql server\data\*.*'. If it returns with an error then you have an invalid path. Hope it helps. David. |
 |
|
|
|
|
|
|
|
MS SQL Server 7.0 And NAS Device...