.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

how many GB or TB data we Store in to SQL

Posted By: kamlesh     Posted Date: March 29, 2011    Points:5   Category :Sql Server
hi

can any body tell me that how many GB or TB data we Store in to SQL server 2005 database
means how many GB it Supports






Responses
Author: Mahesh             
Posted Date: March 29, 2011     Points: 20   

Hi Kamlesh,
follow the link below which may help you,

http://weblogs.sqlteam.com/mladenp/archive/2007/07/24/60267.aspx

Thanks & Regards
Mahesh

Author: kamlesh             
Posted Date: March 29, 2011     Points: 20   

Thanks Mahesh but Upto wt limit we can store data into database means all
data like GB or TB (4GB or 5 GB or 6 GB)


Thanks And Regards.
Kamlesh Nikam
Author: Mahesh             
Posted Date: March 29, 2011     Points: 20   

Hi Kamlesh,
I think so we can store 16 TB of data

Thanks & Regards
Mahesh

Author: kamlesh             
Posted Date: March 29, 2011     Points: 20   

so it for One Database or for all present database

Thanks And Regards.
Kamlesh Nikam
Author: Mahesh             
Posted Date: March 29, 2011     Points: 20   

you can follow the link for details,

http://www.sqldev.org/getting-started-with-sql-server/maximum-sql-2005-database-size-107313.shtml

Thanks & Regards
Mahesh

Author: kamlesh             
Posted Date: March 29, 2011     Points: 20   

and What is ultimate size limitation for SQL Server Management Studio Express ?



Thanks And Regards.
Kamlesh Nikam
Author: Karthikeyan Anbarasan       [Moderator]      
Posted Date: March 29, 2011     Points: 20   

Hi,

SQL Server space depends on the size we specify at the intial stage, also the space of the server...

Thanks
Karthik
http://www.f5debug.net
Mark as Answer if the answer solves your issue!!!
Author: Pandian             
Posted Date: March 29, 2011     Points: 20   

Hi

I agree with Mahesh

Data file can be 16 TB and Log file can be 2 TB.

Cheers

If not I then who, If not now then when
Author: Maverick             
Posted Date: March 29, 2011     Points: 20   

Hello

Yes its true datafile can be upto 16 TB and log file can be upto 2 TB

Thanks,
Maverick

Thanks,
Maverick
Author: Karthikeyan Anbarasan       [Moderator]      
Posted Date: March 29, 2011     Points: 20   

Hi,

If we can see this link below you can see practically the size of the database will be more TB...

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Thanks
Karthik
http://www.f5debug.net
Mark as Answer if the answer solves your issue!!!
Author: kamlesh             
Posted Date: March 30, 2011     Points: 20   

Thanks To All

Thanks And Regards.
Kamlesh Nikam
Author: Karthikeyan Anbarasan       [Moderator]      
Posted Date: March 31, 2011     Points: 20   

Sure welcome kamlesh!!!

Thanks
Karthik
http://www.f5debug.net
Mark as Answer if the answer solves your issue!!!


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend