I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf) file to MSSQL EXpress 2005 engine using MSS Management Studio Express but I get message that attaching databases from network paths is impossible. Is there any possibility to do this?
thx, Tom
Attaching database files in a network location is not recommended. The reason being that SQL Server needs exclusive access to the files, and also needs to ensure that reads and writes are of sufficient speed. The reads and writes also need to follow guaranteed sequence. Very few network devices can satisfy these requirements.
Here's an article that describes the issue in great detail: http://support.microsoft.com/kb/304261/en-us
No comments:
Post a Comment