You’re offline. This is a read only version of the page.
what does SQL have an unlimited DB ?
currently, I am using SQL 2008 R2 witch has a 10 gb limit.
and how to check that how much gb left of sql db.
Thank you.
*This post is locked for comments
Thank you for all reply.
how can I check the Maximun DB size?
To view current size you can run Store Operations or Headquarters Administrator, File, Connect, enter SQL password, OK, then select Database, Properties.
Have you tried this?
USE databaseNameHere
GO
SELECT DB_NAME() AS DbName,
name AS FileName,
size/128.0 AS CurrentSizeMB,
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB
FROM sys.database_files;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (