473,320 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Max database size on SQL-SERVER7

Hello

Does anyone one know the max size of a database that I can create on
MS-SQL server 7. Have had any problems using databases near the max
size (slow performance, etc)
Thanks
Helena
Jul 20 '05 #1
2 3112
hm*******@yahoo.ca (Helena) wrote in message news:<c5**************************@posting.google. com>...
Hello

Does anyone one know the max size of a database that I can create on
MS-SQL server 7. Have had any problems using databases near the max
size (slow performance, etc)
Thanks
Helena


Hi Helena,

According to Books Online, it's 1,048,516 TB which is definitely a big DB.
Yes definitely for DBs os this size, the hardware needs would change.

Regards,
-Manoj
Jul 20 '05 #2

"Helena" <hm*******@yahoo.ca> wrote in message
news:c5**************************@posting.google.c om...
Hello

Does anyone one know the max size of a database that I can create on
MS-SQL server 7. Have had any problems using databases near the max
size (slow performance, etc)
Backups are generally one of the biggest problems I've seen with VLDBs.

You have to have a backup/restore strategy that works for your business
rules.

If it takes 24 hours to restore your database and business rules require you
to back it up in less than 6, you'll have to change your infrastructure.

Generally performance comes down a LOT to design. Proper hardware can make
a huge difference, but even with extremely fast hardware, if you have a
lousy design and end up doing a table scan of a multigig DB, your
performance will suck.

On the other hand, if you have mediocre hardware, but you can do index
lookups for every query (as opposed to a table scan) you'll do a lot better.



Thanks
Helena

Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
by: dchow | last post by:
Our database size is currently 4G and is incrementing at a rate of 45M/day. What is the max size of a SQL database? And what is the size beyond which the server performance will start to go down?
6
by: Marvin Libson | last post by:
Hi All: I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I have created a java UDF and trigger. When I update my database I get the following error: SQL1224N A database...
2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
2
by: marvin | last post by:
Hi, I am trying to display images in a repeater from a SQL database and do some transformations on the image prior to displaying them (such as thumbnail with a shadow). The problem is I can't...
26
by: Jimmy | last post by:
ill have a database with 1 table and 3 fields: ID FIRSTNAME LASTNAME (the ID field will be the auto incrementing index) there might be 10 records in the DB, there might be 10,000. i...
3
mmarif4u
by: mmarif4u | last post by:
Hi everybody, I already post a thread like this but that was in mysql. Here i have a problem with all the code,, <?php // signup.php include("common.php"); include("db.php");
1
by: luvkling | last post by:
hi, i am new to asp.net. i currently doin a website. i created a add form in this form the user need to add in the record n when they press the submit button it will add the record into the access...
221
Atli
by: Atli | last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application...
5
by: aleu | last post by:
Hi all, Could you please advise whether there are documents describing impact of MS SQL server 2005 database size on its performance? I have essentially two things in mind when writing the...
9
by: gavy7210 | last post by:
hello friends i am new to struts. i want to add the user information in the database and then display it back to him. i am using struts 1.2,Eclipse Platform Version: 3.4.2,mySql 5.0.1,jdk...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.