Using 4.3.4 on a F540, 256MB RAM, 8MB NVRAM.
I'm using the oh-so-secret method of using SQL server on a filer... Initial tests with small databases have been great.
Big problem:
I can't create a database device larger than 4GB's on the CIFS share. Anything up to 4 is fine, anything over, uh huh.
Local drives can handle larger, but that's not where I want to be...
1) Any ideas on whats wrong here?
2) Anybody else using a filer under SQL server?
Using 4.3.4 on a F540, 256MB RAM, 8MB NVRAM.
I'm using the oh-so-secret method of using SQL server on a filer... Initial tests with small databases have been great.
Big problem:
I can't create a database device larger than 4GB's on the CIFS share.
Does a database device consist of one file?
If so, the problem is that we don't support files >4GB in releases prior to ONTAP 5.1.
Correct, 1 database can conceivably consist of 2 files, the database itself, and the transaction log.
This answers the question though, although it's a bummer.
I guess I need to upgrade to 5.1. Is the limit only on CIFS shares or any files over 4GB?
Perhaps SQL 7.0 allows a database to consist of more than one device, I haven't tried it yet.
On Thu, 24 Dec 1998, Guy Harris wrote:
Using 4.3.4 on a F540, 256MB RAM, 8MB NVRAM.
I'm using the oh-so-secret method of using SQL server on a filer... Initial tests with small databases have been great.
Big problem:
I can't create a database device larger than 4GB's on the CIFS share.
Does a database device consist of one file?
If so, the problem is that we don't support files >4GB in releases prior to ONTAP 5.1.