asked on
maxsize information
1) Is is possible to query SQL 2005 to see if any databases have a maxsize set? could you provide a syntax? ideally with how much free space is left until the DB hits that maxsize..
2) Is it only the database you set a maxsize for or is the same done for log files? If log files can the query above be tweaked to cover both?
3) If you do set a maxsize for a database - what would ultimately happen if the admin wasnt monitoring remaining space and it hit that maxsize and the admin hadnt added more capacity to the max size?
4) if you don't have a maxsize set, is the only real thing to worry about in terms of space management the free space on the drive on which the databases reside?
2) Is it only the database you set a maxsize for or is the same done for log files? If log files can the query above be tweaked to cover both?
3) If you do set a maxsize for a database - what would ultimately happen if the admin wasnt monitoring remaining space and it hit that maxsize and the admin hadnt added more capacity to the max size?
4) if you don't have a maxsize set, is the only real thing to worry about in terms of space management the free space on the drive on which the databases reside?
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
Last Comment
Pau Lo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks scott