|
|
Posted by Erland Sommarskog on 07/20/05 11:06
charles Collin (charles-henri.collin@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, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|