469,167 Members | 1,216 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

SQLServer and network shares

Hi,

My SQL server is short on disk space and I need to create a new instance
of SQLServer. I had another server running Linux with enough space left
so i create a new partition on it and shared it through SAMBA.
Now I can use this shared disk in RW mode from the SQL server (tested OK).
However, when i try to create another database on this network share,
SQLServer denies the operation.
Does anybody have a clue about what's going on?
Isn't it possible to set database files on a network share?

Regards.

CH COLLIN
Jul 23 '05 #1
2 1522
charles Collin (ch******************@unilog.fr) writes:
My SQL server is short on disk space and I need to create a new instance
of SQLServer. I had another server running Linux with enough space left
so i create a new partition on it and shared it through SAMBA.
Now I can use this shared disk in RW mode from the SQL server (tested OK).
However, when i try to create another database on this network share,
SQLServer denies the operation.
Does anybody have a clue about what's going on?
Isn't it possible to set database files on a network share?


No!

SQL Server must be sure that data is actually written to the disk, and
not sitting in a buffer somewhere.

Assume this:
1) Data is just sitting in a buffer somewhere.
2) SQL Server thinks that the is on disk.
3) So SQL Server commits the data.
4) Someone pulls the plug and everything goes black.
5) When the server comes back, the data is no longer there. This means
that you in some sense have a corrupt database.

I suggest that you see your local hardware vendor.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
As Erland has explained, database on the network would be the deathwish
option, that's why it's not supported.

Is it the transaction log that's eating disk space? When did you last
do a log backup? Take a look at:
http://support.microsoft.com/?kbid=873235

--
David Portas
SQL Server MVP
--

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Homer Blankenship | last post: by
6 posts views Thread by Default User | last post: by
5 posts views Thread by Josh Rolfe | last post: by
2 posts views Thread by Michael | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.