This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

What are the backup and restore limitations?

Question
0

Sign in to vote

Hello Community

     Recently I have read something that I never thought about.

     Can SQL Server backup and/or restore a database that is 4TB or larger?

    Thank you
    Shabeaut

Sunday, November 3, 2013 10:08 PM

Answers

0

Sign in to vote
Yes. It will take some time of course, all depending on your hardware.

I don't know the exact size of the biggest SQL Server database out there, but I believe it extends beyond 1 PB = 1000 TB.

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
- Marked as answer by Shabeaut Monday, November 4, 2013 12:35 AM
Sunday, November 3, 2013 10:37 PM
0

Sign in to vote
Maximum database size in SQL Server is :

524,272 terabytes

For more info see this link:

Maximum Capacity Specifications for SQL Server
Saeid Hasani, sqldevelop.wordpress.com

Download Books Online for SQL Server 2012
- Proposed as answer by Vedran Kesegic Monday, November 4, 2013 12:29 AM
- Marked as answer by Shabeaut Monday, November 4, 2013 12:35 AM
Sunday, November 3, 2013 10:41 PM

All replies

0

Sign in to vote
Yes. It will take some time of course, all depending on your hardware.

I don't know the exact size of the biggest SQL Server database out there, but I believe it extends beyond 1 PB = 1000 TB.

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
- Marked as answer by Shabeaut Monday, November 4, 2013 12:35 AM
Sunday, November 3, 2013 10:37 PM
0

Sign in to vote
Maximum database size in SQL Server is :

524,272 terabytes

For more info see this link:

Maximum Capacity Specifications for SQL Server
Saeid Hasani, sqldevelop.wordpress.com

Download Books Online for SQL Server 2012
- Proposed as answer by Vedran Kesegic Monday, November 4, 2013 12:29 AM
- Marked as answer by Shabeaut Monday, November 4, 2013 12:35 AM
Sunday, November 3, 2013 10:41 PM