/****缩小vCenter数据库的sql 语句***/
/****缩小vCenter数据库的sql 语句***/
use vcdb;--vcdb是vCenter数据库的名称,如果是其它名称,请将脚本中所有的vcdb更换成实际的名称。
go
deletefrom dbo.VPX_EVENT_ARG;--删除事件日志表
deletefromdbo.VPX_EVENT;--删除事件日志表
droptable dbo.VPX_HIST_STAT1;--删除表dbo.VPX_HIST_STAT1;
droptable dbo.VPX_HIST_STAT2;--删除表dbo.VPX_HIST_STAT2;
droptable dbo.VPX_HIST_STAT3;--删除表dbo.VPX_HIST_STAT3;
droptable dbo.VPX_HIST_STAT4;--删除表dbo.VPX_HIST_STAT4;
USE [VCDB]
GO
/****** 重建表对象:Table [dbo].[VPX_HIST_STAT1]脚本日期: 12/17/2013 15:32:57 ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[VPX_HIST_STAT1](
[COUNTER_ID] [bigint] NOTNULL,
[TIME_ID] [bigint] NOTNULL,
[STAT_VAL] [bigint] NOTNULL
)ON [PRIMARY]
/****** 重建表对象:Table [dbo].[VPX_HIST_STAT1]完成******/
USE [VCDB]
GO
/****** 重建表对象:Table [dbo].[VPX_HIST_STAT2]脚本日期: 12/17/2013 15:33:30 ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[VPX_HIST_STAT2](
[COUNTER_ID] [bigint] NOTNULL,
[TIME_ID] [bigint] NOTNULL,
[STAT_VAL] [bigint] NOTNULL
)ON [PRIMARY]
/****** 重建表对象:Table [dbo].[VPX_HIST_STAT2]完成脚本日期: 12/17/2013 15:33:30 ******/
USE [VCDB]
GO
/****** 重建表对象:Table [dbo].[VPX_HIST_STAT3]脚本日期: 12/17/2013 15:34:20 ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[VPX_HIST_STAT3](
[COUNTER_ID] [bigint] NOTNULL,
[TIME_ID] [bigint] NOTNULL,
[STAT_VAL] [bigint] NOTNULL
)ON [PRIMARY]
/****** 重建表对象:Table [dbo].[VPX_HIST_STAT3]完成 ******/
USE [VCDB]
GO
/****** 重建表对象:Table [dbo].[VPX_HIST_STAT4]脚本日期: 12/17/2013 15:34:57 ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[VPX_HIST_STAT4](
[COUNTER_ID] [bigint] NOTNULL,
[TIME_ID] [bigint] NOTNULL,
[STAT_VAL] [bigint] NOTNULL
)ON [PRIMARY]
/****** 重建表对象:Table [dbo].[VPX_HIST_STAT4]完成 ******/
/****** 收缩数据库 ******/
USE [VCDB]
GO
DBCC SHRINKDATABASE(N'VCDB')
GO
/****** 收缩数据库 ******/
|