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 - 2006-01-10 : 08:13:59
|
| Ramachandran writes "We had been using NAS to keep the mdf and ldf of the all the databases in SQL 2000 server.Using the dbcc traceon (1807) command we were able to place the mdf/ldf for the database and mount the sqlserver.Now we have decided to upgrade the latest MS SQL 2005 server(Windows 2000 Server OS). but when tried to do the same in SQL2005 the system doesnt create database. it displays the NAS path in the network but when we click on Add it diplays create database not possible over network. How can I resolve this issue??" |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-15 : 14:58:27
|
| I think you need to add -T1807 as a start up option - you can't just turn it on with DBCC TRACEON. I have tried it that way and it works fine. |
 |
|
|
|
|
|
SQL2005 with NAS