| 发表于：2007-09-02 12:54:193楼 得分:50 |
use [msdb]
go
/****** 对象: table [dbo].[backupset] 脚本日期: 09/02/2007 12:51:17 ******/
set ansi_nulls on
go
set quoted_identifier on
go
set ansi_padding on
go
create table [dbo].[backupset]（
[backup_set_id] [int] identity（1,1) not null,
[backup_set_uuid] [uniqueidentifier] not null,
[media_set_id] [int] not null,
[first_family_number] [tinyint] null,
[first_media_number] [smallint] null,
[last_family_number] [tinyint] null,
[last_media_number] [smallint] null,
[catalog_family_number] [tinyint] null,
[catalog_media_number] [smallint] null,
[position] [int] null,
[expiration_date] [datetime] null,
[software_vendor_id] [int] null,
[name] [nvarchar]（128) null,
[description] [nvarchar]（255) null,
[user_name] [nvarchar]（128) null,
[software_major_version] [tinyint] null,
[software_minor_version] [tinyint] null,
[software_build_version] [smallint] null,
[time_zone] [smallint] null,
[mtf_minor_version] [tinyint] null,
[first_lsn] [numeric]（25, 0) null,
[last_lsn] [numeric]（25, 0) null,
[checkpoint_lsn] [numeric]（25, 0) null,
[database_backup_lsn] [numeric]（25, 0) null,
[database_creation_date] [datetime] null,
[backup_start_date] [datetime] null,
[backup_finish_date] [datetime] null,
[type] [char]（1) null,
[sort_order] [smallint] null,
[code_page] [smallint] null,
[compatibility_level] [tinyint] null,
[database_version] [int] null,
[backup_size] [numeric]（20, 0) null,
[database_name] [nvarchar]（128) null,
[server_name] [nvarchar]（128) null,
[machine_name] [nvarchar]（128) null,
[flags] [int] null,
[unicode_locale] [int] null,
[unicode_compare_style] [int] null,
[collation_name] [nvarchar]（128) null,
[is_password_protected] [bit] null,
[recovery_model] [nvarchar]（60) null,
[has_bulk_logged_data] [bit] null,
[is_snapshot] [bit] null,
[is_readonly] [bit] null,
[is_single_user] [bit] null,
[has_backup_checksums] [bit] null,
[is_damaged] [bit] null,
[begins_log_chain] [bit] null,
[has_incomplete_metadata] [bit] null,
[is_force_offline] [bit] null,
[is_copy_only] [bit] null,
[first_recovery_fork_guid] [uniqueidentifier] null,
[last_recovery_fork_guid] [uniqueidentifier] null,
[fork_point_lsn] [numeric]（25, 0) null,
[database_guid] [uniqueidentifier] null,
[family_guid] [uniqueidentifier] null,
[differential_base_lsn] [numeric]（25, 0) null,
[differential_base_guid] [uniqueidentifier] null,
primary key clustered
（
[backup_set_id] asc
)with （pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary]
) on [primary]
go
set ansi_padding off
go
/****** 对象: index [backupsetuuid] 脚本日期: 09/02/2007 12:51:18 ******/
create nonclustered index [backupsetuuid] on [dbo].[backupset]
（
[backup_set_uuid] asc
)with （pad_index = off, statistics_norecompute = off, sort_in_tempdb = off, ignore_dup_key = off, drop_existing = off, online = off, allow_row_locks = on, allow_page_locks = on) on [primary]
go
alter table [dbo].[backupset] with check add foreign key（[media_set_id])
references [dbo].[backupmediaset] （[media_set_id]) | | |
|
