select t.name as TableName, Min(t.create_date) as CreateDate, ds.name as FileGroupName, SUM(u.total_pages) * 8 / 1024 as SizeMB
from sys.tables as t
inner join sys.partitions as p on t.object_id = p.object_id
inner join sys.allocation_units as u on p.partition_id = u.container_id
inner join sys.data_spaces as ds on u.data_space_id = ds.data_space_id
group by t.name, ds.name
order by SizeMB desc
use master
alter database tempdb
modify file(
name = tempdev,
filename = N'Z:\TEMP\tempdb.mdf')
go
alter database tempdb
modify file(
name = templog,
filename = N'Z:\TEMP\templog.ldf')
go
use master
go
sp_configure 'allow updates', 1 reconfigure with override
go
alter database [имя базы] set emergency
go
alter database [имя базы] set single_user
go
dbcc checkdb ('[имя базы]', REPAIR_ALLOW_DATA_LOSS)
go
alter database [имя базы] set multi_user