File size limit

  • Thread starter msnews.microsoft.com
  • Start date
M

msnews.microsoft.com

Hi,


Is there any limit we have on SQL server for 10GB database.



please i need your comments guys.


Regards.
AD Rehman.
 
B

Brendan Reynolds

I'm not quite sure whether you mean that you're having a problem going
beyond 10GB, or that you want to limit the database to 10GB. But the answer
may be the same, anyway.

In SQL Server Enterprise Manager, right-click the icon for your database,
and choose Properties. Now select the Data Files tab, and look at the
'Maximum file size' options down near the bottom right of the dialog box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top