[dbo].[backup_backed_up_file

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	12:30:46 PM Sunday, December 05, 2010
Last Modified	12:30:46 PM Sunday, December 05, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

12:30:46 PM Sunday, December 05, 2010

Last Modified

12:30:46 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKbackup_backed_up_file_revision: user_id\backup_run_date\backed_up_file_id$ $Indexes xif2backup_backed_up_file_revisi: backup_run_date\user_id$ $Indexes xif1backup_backed_up_file_revisi: user_id\backup_run_date\backed_up_file_id\backed_up_folder_id$	user_id	binary(16)	16
$Cluster Primary Key XPKbackup_backed_up_file_revision: user_id\backup_run_date\backed_up_file_id$ $Indexes xif2backup_backed_up_file_revisi: backup_run_date\user_id$ $Indexes xif1backup_backed_up_file_revisi: user_id\backup_run_date\backed_up_file_id\backed_up_folder_id$	backup_run_date	int	4
$Cluster Primary Key XPKbackup_backed_up_file_revision: user_id\backup_run_date\backed_up_file_id$ $Indexes xif1backup_backed_up_file_revisi: user_id\backup_run_date\backed_up_file_id\backed_up_folder_id$	backed_up_file_id	varbinary(16)	16
	revision	int	4
	file_size	int	4
	compressed_size	int	4
	last_modified	int	4
	win32_file_type	varbinary(4)	4
	presence_type	varbinary(4)	4
	creation_user	nvarchar(64)	128
	creation_date	int	4
	file_size_high	int	4
	compressed_size_high	int	4
$Indexes xif1backup_backed_up_file_revisi: user_id\backup_run_date\backed_up_file_id\backed_up_folder_id$	backed_up_folder_id	varbinary(16)	16

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKbackup_backed_up_file_revision: user_id\backup_run_date\backed_up_file_id$ $Indexes xif2backup_backed_up_file_revisi: backup_run_date\user_id$ $Indexes xif1backup_backed_up_file_revisi: user_id\backup_run_date\backed_up_file_id\backed_up_folder_id$

user_id

binary(16)

backup_run_date

int

$Cluster Primary Key XPKbackup_backed_up_file_revision: user_id\backup_run_date\backed_up_file_id$ $Indexes xif1backup_backed_up_file_revisi: user_id\backup_run_date\backed_up_file_id\backed_up_folder_id$

backed_up_file_id

varbinary(16)

revision

int

file_size

int

compressed_size

int

last_modified

int

win32_file_type

varbinary(4)

presence_type

varbinary(4)

creation_user

nvarchar(64)

128

creation_date

int

file_size_high

int

compressed_size_high

int

$Indexes xif1backup_backed_up_file_revisi: user_id\backup_run_date\backed_up_file_id\backed_up_folder_id$

backed_up_folder_id

varbinary(16)

	Name	Columns
$Cluster Primary Key XPKbackup_backed_up_file_revision: user_id\backup_run_date\backed_up_file_id$	XPKbackup_backed_up_file_revision	user_id, backup_run_date, backed_up_file_id
	xif1backup_backed_up_file_revisi	user_id, backup_run_date, backed_up_file_id, backed_up_folder_id
	xif2backup_backed_up_file_revisi	backup_run_date, user_id

Name

Columns

Unique

$Cluster Primary Key XPKbackup_backed_up_file_revision: user_id\backup_run_date\backed_up_file_id$

XPKbackup_backed_up_file_revision

user_id, backup_run_date, backed_up_file_id

xif1backup_backed_up_file_revisi

user_id, backup_run_date, backed_up_file_id, backed_up_folder_id

xif2backup_backed_up_file_revisi

backup_run_date, user_id

Type	Action	Owning Principal
Grant	Delete	backup_admin_group
Grant	Insert	backup_admin_group
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Delete	dms_backup_group
Grant	Insert	dms_backup_group
Grant	Select	backup_admin_group
Grant	Update	backup_admin_group
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	ca_itrm_group_ams
Grant	Select	dms_backup_group
Grant	Update	dms_backup_group

Type

Action

Owning Principal

Grant

Delete

backup_admin_group

Grant

Insert

backup_admin_group

Grant

Delete

ca_itrm_group

Grant

Insert

ca_itrm_group

Grant

Delete

dms_backup_group

Grant

Insert

dms_backup_group

Grant

Select

backup_admin_group

Grant

Update

backup_admin_group

Grant

Select

ca_itrm_group

Grant

Update

ca_itrm_group

Grant

Select

ca_itrm_group_ams

Grant

Select

dms_backup_group

Grant

Update

dms_backup_group

SQL Script

CREATE TABLE [dbo].[backup_backed_up_file_revision]
(
[user_id] [binary] (16) NOT NULL,
[backup_run_date] [int] NOT NULL,
[backed_up_file_id] [varbinary] (16) NOT NULL,
[revision] [int] NULL,
[file_size] [int] NULL,
[compressed_size] [int] NULL,
[last_modified] [int] NULL,
[win32_file_type] [varbinary] (4) NULL,
[presence_type] [varbinary] (4) NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[file_size_high] [int] NULL,
[compressed_size_high] [int] NULL,
[backed_up_folder_id] [varbinary] (16) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[backup_backed_up_file_revision] ADD CONSTRAINT [XPKbackup_backed_up_file_revision] PRIMARY KEY CLUSTERED ([user_id], [backup_run_date], [backed_up_file_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2backup_backed_up_file_revisi] ON [dbo].[backup_backed_up_file_revision] ([backup_run_date], [user_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1backup_backed_up_file_revisi] ON [dbo].[backup_backed_up_file_revision] ([user_id], [backup_run_date], [backed_up_file_id], [backed_up_folder_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[backup_backed_up_file_revision] TO [backup_admin_group]
GRANT INSERT ON  [dbo].[backup_backed_up_file_revision] TO [backup_admin_group]
GRANT DELETE ON  [dbo].[backup_backed_up_file_revision] TO [backup_admin_group]
GRANT UPDATE ON  [dbo].[backup_backed_up_file_revision] TO [backup_admin_group]
GRANT SELECT ON  [dbo].[backup_backed_up_file_revision] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[backup_backed_up_file_revision] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[backup_backed_up_file_revision] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[backup_backed_up_file_revision] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[backup_backed_up_file_revision] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[backup_backed_up_file_revision] TO [dms_backup_group]
GRANT INSERT ON  [dbo].[backup_backed_up_file_revision] TO [dms_backup_group]
GRANT DELETE ON  [dbo].[backup_backed_up_file_revision] TO [dms_backup_group]
GRANT UPDATE ON  [dbo].[backup_backed_up_file_revision] TO [dms_backup_group]
GO