dlafferty
asked on
How do I manage the SharePoint Config Database, the LDF file is over 15GB, and the SQL managment Studio doesnt show the Database
I have an SBS 2008 Server with Sharepoint installed, I cannot manage the database in SQL to truncate or shrink the .LDF file that is 15GB. I have SQL 2005 managment studio express but dont know how to open the .MDF file or .LDF file. My SQL managment studio only lets me open ,the SBSMonitoring and a few other Databases we have in office. Once I open them I can shrink it or back it up and that should eliminate the LDF file.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Database files are not readable by anything else than the SQL Server engine and both DATA and LOG files are required to connect a specific database to a SQL Server instance. SQL Server is not Access or word.
What was the solution exactly?
Achilles problem was that Dlafferty has a data and log file which size was more than 15Gb. But he was trying with sql server 2005 express edition is limited to maximum 10 GB.
I understand the problem. What was the solution?
use standard /enterprose/ developer edition of sql server to open more than 10Gb mdf / ldf files
database size limit...................=
sql server 2005 express limit is 4 GB max.
sql server 2008 express limit is 4 GB max
sql server 2008 R2 express limit is 10 GB max. and
sql server standard / enterprise. developer edition limit is unlimited
database size limit...................=
sql server 2005 express limit is 4 GB max.
sql server 2008 express limit is 4 GB max
sql server 2008 R2 express limit is 10 GB max. and
sql server standard / enterprise. developer edition limit is unlimited
deepakChauhan
Dlafferty has a data and log file which size was more than 15Gb. But he was trying with sql server 2005 express edition is limited to maximum 10 GB.
Be careful with the misinfromation. The SQL Server 2005 Express Edition only supports data up to 4 GB not 10GB. Also, that has no bearing on the size of the data and Transaction log files. They can be 100 GB each and you can still use the database, provided that the data does not exceed 4GB with SQL Server 2005 Express Edition and 10GB for SQL Server 2008-R2 Express Edition.
use standard /enterprose/ developer edition of sql server to open more than 10Gb mdf / ldf files
Again that is not correct. Please check your facts first.
Dlafferty has a data and log file which size was more than 15Gb. But he was trying with sql server 2005 express edition is limited to maximum 10 GB.
Be careful with the misinfromation. The SQL Server 2005 Express Edition only supports data up to 4 GB not 10GB. Also, that has no bearing on the size of the data and Transaction log files. They can be 100 GB each and you can still use the database, provided that the data does not exceed 4GB with SQL Server 2005 Express Edition and 10GB for SQL Server 2008-R2 Express Edition.
use standard /enterprose/ developer edition of sql server to open more than 10Gb mdf / ldf files
Again that is not correct. Please check your facts first.