Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 54

Database File Options, Use Current ARCserve Database as Original Location

Get Computer Associates SQLSTQ99000600 - Unicenter SQL-Station 6.0.0 PDF manuals and user guides
UPC - 757943257441
View all Computer Associates SQLSTQ99000600 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 54 highlights

Database File Options Restricted User Access After Restore Option Restricts access to a newly restored database to members of the db_owner, dbcreator, or sysadmin roles. In Microsoft SQL Server 2000 and Microsoft SQL Server 2005, Restricted_User replaces the DBO_Only option from Microsoft SQL Server 7.0. This option requires the Leave database operational, no additional transaction logs can be restored option. Keep Replication Settings Instructs the restore operation to preserve replication settings when restoring a published database to a server other than the one on which it was created. This prevents Microsoft SQL Server from resetting the replication settings when it restores a database or log backup on a warm standby server and recovers the database. Use the Keep Replication Settings option when setting up replication to work with log shipping. You cannot select this option when restoring a backup with the Leave database non-operational, but able to restore additional transaction logs option. Use this option only with the Leave database operational, no additional transaction logs can be restored option. Use Current ARCserve Database as Original Location Overwrites the current ARCserve Database instead of the database which was backed up to this session when a restore to Original Location is selected. You can use this option to migrate the session and log information from one ARCserve Domain to another. Preserve Current ARCserve Domain Memberships Retrieves the current information about ARCserve Domains, such as the ARCserve Domain name, Primary Server identity, and Member Server identities from the destination database before the restore begins. This information is written back after the restore is completed so that the information is preserved even after the restore. This option is enabled when the Automatic Selection, Leave Database Operational and Use Current ARCserve Database as Original Location options are selected. Database File Options Using the Database File options, you can: ■ View the list of files for the database and related information. ■ Select the files to be restored in a Files and FileGroup restore, or the FileGroups to be restored in a Partial Restore. ■ Change the location or file names of files during a restore. Use the location change function only when restoring from Full backups, or when using Automatic Selection. 54 Agent for Microsoft SQL Server Guide

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
Database File Options
54
Agent for Microsoft SQL Server Guide
Restricted User Access After Restore Option
Restricts access to a newly restored database to members of the db_owner,
dbcreator, or sysadmin roles. In Microsoft SQL Server 2000 and Microsoft
SQL Server 2005, Restricted_User replaces the DBO_Only option from
Microsoft SQL Server 7.0. This option requires the Leave database
operational, no additional transaction logs can be restored option.
Keep Replication Settings
Instructs the restore operation to preserve replication settings when
restoring a published database to a server other than the one on which it was
created. This prevents Microsoft SQL Server from resetting the replication
settings when it restores a database or log backup on a warm standby server
and recovers the database. Use the Keep Replication Settings option when
setting up replication to work with log shipping.
You cannot select this option when restoring a backup with the Leave
database non-operational, but able to restore additional transaction logs
option. Use this option only with the Leave database operational, no
additional transaction logs can be restored option.
Use Current ARCserve Database as Original Location
Overwrites the current ARCserve Database instead of the database which
was backed up to this session when a restore to Original Location is selected.
You can use this option to migrate the session and log information from one
ARCserve Domain to another.
Preserve Current ARCserve Domain Memberships
Retrieves the current information about ARCserve Domains, such as the
ARCserve Domain name, Primary Server identity, and Member Server
identities from the destination database before the restore begins. This
information is written back after the restore is completed so that the
information is preserved even after the restore. This option is enabled when
the Automatic Selection, Leave Database Operational and Use Current
ARCserve Database as Original Location options are selected.
Database File Options
Using the Database File options, you can:
■
View the list of files for the database and related information.
■
Select the files to be restored in a Files and FileGroup restore, or the
FileGroups to be restored in a Partial Restore.
■
Change the location or file names of files during a restore. Use the location
change function only when restoring from Full backups, or when using
Automatic Selection.