Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

Remote data

I have the sql server on a nt workstation and also have a novell server. Is it possible to have the database on the novell server and have the sqlserver reference information from the novell server?
0
turbo1
Asked:
turbo1
1 Solution
 
jbiswasCommented:
No you don't wanna do that. The reason you cannot have your datafiles in a remote server is that, what if the network is down, where will the sql server write to? So there is no way you should do that. Besides I'm not even sure the SQL Server will allow you to create a device on a mapped drive. So the answer to your question is NO, you cannot do it.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now