Listare fisiere baze de date ce stau pe o anumita partitie

Home /Servicii baze de date/SQL Server/Listare fisiere baze de date ce stau pe o anumita partitie
Home /Servicii baze de date /Listare fisiere baze de date ce stau pe o anumita partitie

Configurare noua (How To)

Mai jos este o procedura ce listeaza toate fisierele de baze de date MSSQL Server care se afla pe o anumita partitie.

— exec DatabaseOnDriveLetterX ‘c’

ALTER PROCEDURE DatabaseOnDriveLetterX

@x varchar(1)

SELECT DISTINCT

[dbid] = [s1].[dbid],

[dbname] = DB_NAME([s1].[dbid]),

[logical_name] = [s1].[name],

DriveLetter = left([s1].[filename],1)

FROM [master].[dbo].[sysaltfiles] AS [s1]

INNER JOIN [master].[dbo].[sysaltfiles] AS [s2] ON [s1].[dbid] = [s2].[dbid]

AND LEFT(RTRIM([s1].[filename]), 1) = LEFT(RTRIM([s2].[filename]), 1)

WHERE [s1].[groupid] = 0

AND [s2].[groupid] = 1

AND upper(left([s1].[filename],1)) = upper(@x)

Permanent

Up Down

(8 din 12 persoane apreciaza acest articol)