Hi,
I have installed SQL server 2005 in my machine. Now when we restore the database, I have check the size of database file .mdf/.ldf is very large. So now I wants to place these two files in any other machine in network.
But when I try to do the same, I am getting "Error 5110: network device not supported for database files.".
Please anyone guide me about the process. So that I can place these 2 files in another machine in network or any sharepoint.
Thanks
Regards,
Nipun
The ability to run databases off network drives is not supported by Microsoft. However, it is possible by setting trace flag 1807. Read all about it in the following KB article:
http://support.microsoft.com/kb/304261
HTH!
|||To keep a long answer short, this is not suggested as network shares are (evil) unreliable as long as they are not build for storing and doing reliable processing (like NAS).
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||As Jens indicated, it is generally NOT a good idea to put the data files on a network share.
(Using a SAN or NAS is quite different and approved.)
No comments:
Post a Comment