Führe doch mal bitte dieses Skript aus und poste hier das Ergebnis um mal einen Überblick zu bekommen wie es mit der Datenbank und dem Server aussieht
USE master;
GO
-- Dirty reads zulassen, um möglichst keine Ressourcen zu sperren!
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
GO
-- Variables for the passing through all databases
DECLARE @Result TABLE
(
Database_Name sysname NOT NULL,
Database_Owner sysname NULL,
compatibility_level VARCHAR(10) NOT NULL,
collation_Name sysname NOT NULL,
state_mode VARCHAR(30) NOT NULL,
recovery_mode VARCHAR(30) NOT NULL,
snapshot_isolation VARCHAR(5) NOT NULL DEFAULT ('OFF'),
read_committed_SI TINYINT NOT NULL DEFAULT (0),
Logical_Name sysname NOT NULL,
type_desc VARCHAR(10) NOT NULL,
physical_name VARCHAR(255) NOT NULL,
size_MB DECIMAL(18, 2) NOT NULL DEFAULT (0),
growth_MB DECIMAL(18, 2) NOT NULL DEFAULT (0),
used_MB DECIMAL(18, 2) NOT NULL DEFAULT (0),
is_percent_growth TINYINT NOT NULL DEFAULT (0),
percent_growth TINYINT NOT NULL DEFAULT (0),
PRIMARY KEY CLUSTERED
(
Database_Name,
logical_name
),
UNIQUE (physical_name)
);
INSERT INTO @Result
EXEC sys.sp_MSforeachdb @command1 = N'USE [?];
SELECT DB_NAME(D.database_id) AS [Database Name],
SP.name AS [Database_Owner],
D.compatibility_level,
D.collation_name,
D.state_desc,
D.recovery_model_desc,
D.snapshot_isolation_state_desc,
D.is_read_committed_snapshot_on,
MF.name,
MF.type_desc,
MF.physical_name,
MF.size / 128.0 AS [size_MB],
CASE WHEN MF.[is_percent_growth] = 1
THEN MF.[size] * (MF.[growth] / 100.0)
ELSE MF.[growth]
END / 128.0 AS [growth_MB],
FILEPROPERTY(MF.name, ''spaceused'') / 128.0 AS [used_MB],
MF.[is_percent_growth],
CASE WHEN MF.[is_percent_growth] = 1
THEN MF.[growth]
ELSE 0
END AS [percent_growth]
FROM sys.databases AS D INNER JOIN sys.master_files AS MF
ON (D.database_id = MF.database_id) LEFT JOIN sys.server_principals AS SP
ON (D.owner_sid = SP.sid)
WHERE D.database_id = DB_ID();';
SELECT R.Logical_Name,
R.type_desc,
R.size_MB,
R.growth_MB,
R.used_MB,
R.is_percent_growth,
R.percent_growth
/* for more detailed information about the databases */
--,
--R.Database_Name,
--R.physical_name
FROM @Result AS R;
Benjamin Hoch
MCSE: Data Platform & Data Management and Analytics
MCSA: SQL Server 2012/2014 & 2016 DB Administration
MCSA: Windows Server 2012
