| Author |
Topic |
|
anolis
Starting Member
14 Posts |
 Posted - 2004-05-04 : 13:21:43
|
| Hi,My database is growing really big, it approaches 2GB. My company decided it should not grow bigger than 1.8GB...The database is running on a W2000 Server (not advanced), I have another server available.Question:Is it possible to split the database into two instances of SQL-Server, on two different Servers, without any consequence for the Clients?I mean the following:I have a table called tblContacts. A Query could be:SELECT * FROM tblContacts WHERE etc...I do not want this query to change (as when you use linked servers, where you must provide the full name of the server, catalog etc.), but I want to store tblContacts on another server.Anyone any suggestions?M.C.A.D. for .NET |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-04 : 13:25:20
|
quote:
My company decided it should not grow bigger than 1.8GB...
How did they come up with that decision? Is it just the MDF file that they are talking about? You could use partitioned views I guess to split the database up between two servers. The view would handle unioning the rows together to form a table. BTW, 2GB is not really big. Is it just that you don't have the disk space for it? What is your database recovery model set to for this database? If it is FULL, are you performing TLOG backups?Tara |
 |
|
|
anolis
Starting Member
14 Posts |
Posted - 2004-05-04 : 14:24:00
|
| It is the database size they are talking about ( the one that shows up when you look at the database properties). Someone told them the maximum allowed database size for SQL-Server 2000 is 2GB. I know this is not true, but I have not been able to find any official document that shows the real numbers.... I've got about 40 GB of diskspace left,so that won't be the problem.The recovery model is set to full and I'm performing Tlog backups.Maybe anyone can point me to some documentation about this ( the max. size of a database)? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-04 : 14:31:25
|
| The maximum size for a SQL Server 2000 database is 1,048,516 terabytes. That's huge! I'm not sure what the biggest database out there is, but I believe it's a couple of terabytes IIRC.We've got databases that are around 100GB. We had one that was about 400GB, but we changed our data retention for that database and it's now under 100GB.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.aspTara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-05-04 : 14:32:05
|
| Open up books online, and put this in the keyword search under Index.maximum capacity specificationsMax size is over 1 million TB!!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-05-04 : 14:50:35
|
| They are probably thinking of RAM, I think standard edition SQL can't use more than 2GB of RAM.I guess it's possible that your folks want to get the entre DB into memory, which would be a reason why they would put a limit of 2GB on the DB, but depending on your application I would bet it can be optimized so that wouldn't be a big issue anyhow. |
|
|
|
anolis
Starting Member
14 Posts |
Posted - 2004-05-04 : 16:14:16
|
| Thanks all of you! I just tested some things, I created a 2,7 GB database on my laptop, no problem there. I will show that, and the documentation to convince them.The server has 2GB of RAM, thats a point. However, as crazyjoe says, I don't think that's the isue.Anolis,Developer,MCAD for .NET |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-04 : 21:14:24
|
| They are thinking about MSDE. It has a 2GB database size limit.Damian |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-04 : 21:19:55
|
| I wish my biggest database was only 2gb when it came time to do clones. lolMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-05-04 : 22:01:14
|
quote:
Originally posted by Merkin
They are thinking about MSDE. It has a 2GB database size limit.Damian
That cannot be modified....yet DavidM"If you are not my family or friend, then I will discriminate against you" |
|
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2004-05-04 : 23:59:03
|
quote:
Originally posted by derrickleggett
I wish my biggest database was only 2gb when it came time to do clones. lol
So do i. a backup of mine is now over 600mb compressed (85% compression). Bloody annoying downloading that to a development server.  |
|
|
|
|
2 GB danger ahead...