What is the maximum size of an SQL Server 2000 Database?

Posted by Neeks on 3/5/2009 | Category: Sql Server Interview questions | Views: 7665

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

The maximum size for SQL Server 2000 databases is 1,048,516 TB. Each database can contain up to 32,767 files, and the maximum size of each file is 32TB

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : how many database can be created on MSSQL Server 2 ...

Next > : How you can get the last identity value inserted i ...

Comments or Responses

More Interview Questions by Neeks

How you can get the last identity value inserted in any table ?
What are the limits of Sql Server 2000?
What is the Maximum number of input and output parameters in Stored pr ...
10 Steps to a Successful Interview
State some limitations of style sheets?
What event can you subscribe to if you want to display information fro ...
Which is not the step to create custom SOAP (Simple Object Access Prot ...
What is DESCRIBE command in SQL Server 2005? What is its purpose? How ...

Latest Interview Questions

Should we use table tag to design the layout of the webpage?
How to create a ListBox in HTML?
How to create a DropDown list box?
How to display numbered list in HTML?
How to write bulleted point in HTML?
How to refer the .css file in the web page?
How to display the web page icon in the browser?
How to add javascript file reference in the web page?
More ...