elect the backu erform
elect [Off-site B
estore Mi
ctions below to ad the backup refer to the [Q
m Offsite Back
Microsoft SQL E n open Microso rver] -> [Ente al) Restore “m to restore “m e rebuilding al ave changing a ave added login ave created or ave configured dding linked se ot need to rest ormation on Mi ww.microsoft.c e “master” dat art Microsoft S Right click you
up set you wan
up type (e.g. C
Backup Server]
icrosoft S
o restore your files (.bak) fro uick Start - Ba kup Server.
nterprise Mana ft SQL Enterpr rprise Manage master” databas
aster” databas l your databas ny server-wide ns or other log
removed logic the server for rvers or remot tore your mast crosoft SQL Se om/sql/.
tabase, please SQL Server in “ ur Microsoft SQ
t to run on the
omplete, Diffe
] to start back
SQL Serv
Microsoft SQL om the Offsite ackup File] sect
ager rise Manager fr
r]
se se if you:
es from scratc e or database c
in security-rela al backup devi distributed qu te logins.
ter database if erver “master”
do the followin
“Single User Mo QL Server and
e left panel and
rential, Transa
ing up your file
ver databa
L Server databa Backup Serve tion for inform
rom [Start Men
ch
configuration o ated operation
ces.
ueries and remo
you just want database, ple
ng:
ode”
select [Proper
d press the [St
action Log) you
es to an Offsite
ase(s)
ases from an O r
ation on how t
nu] -> [Progra
options s.
ote procedure
to restore a us ase visit
rties]
tart Backup] bu
u would like to
e Backup Serve
Offsite Backup
to download ba
m] -> [Microso
calls, such as
ser database.
utton
2.
3.
4.
Press the [Sta
Add a “-m” pa
Restart Micros From [Enterpr then [Start].
artup Paramete
arameter to th
soft SQL Serve rise Manager],
ers] button
e [Startup Para
er
right click you
ameters]
ur Microsoft SQQL Server and select [Stop] aand
b. Re 1.
2.
estore “master From [Enterpr
Select [maste
” database rise Manager]
er] in the [Rest
-> [Tools] ->
tore as databas
[Restore Datab
se] drop down base]
list
3.
4.
5.
6.
7.
c. Re 1.
2.
iv. (Option You nee Server.
Select the [Fr Press the [Se
From the [Cho
From the [Cho backup (*.bak
Press the [OK estart Microsoft Remove “-m”
Restart your M al) Restore “m ed to restore “m
rom device] rad lect Devices] b
oose Restore D
oose Restore D k) from your b
K] button, to st t SQL Server in parameter fro Microsoft SQL S model”, “msdb”
model” databa
dio button.
button.
Devices], press
Destination] pa ackup files
tart restoring t n “Normal Mod om the [Startup
Server as in pr
” and “distribut se if you have
s the [Add] but
anel, press the
he “master” da de”
p Parameters]
revious step ion” database changed the d
tton.
[…] button to
atabase.
as in previous
database temp
choose your m
s step
plate of your SQ master
QL
You nee to resto You nee Server.
You do informa http://w You nee please d a. Fro For eac a. Fro
ed to restore “m ore the backup
ed to restore “d
not need to re ation on Micros www.microsoft ed to restore e do the followin om [Enterprise elect the datab elect the [From ess the [Select ess the […] bu ess the [OK] b
e user database h of the databa om [Enterprise elect the datab elect the [Data
om the [Show om the [First b ould like to res ou can restore etween the tim hange the [Res
msdb” databas and restore h distribution” da
estore these da oft SQL Server t.com/sql/.
ach of these d g:
e Manager] ->
ase to be resto m device] radio t Devices] butt utton to choose button
e(s)
ase you would e Manager] ->
ase to be resto base] radio bu
backups of da backup to resto store to.
your database e you did your store From] en
se if you have istory of your d atabase if you
atabases if you r “model”, “ms
atabases one b
[Tools] -> [Re ored in the [Re
button.
ton
e your backup f
like to restore [Tools] -> [Re ored in the [Re utton.
atabase] drop d ore] drop down
to the snapsh r full backup a
try
changed the sc databases.
are running th
just want to r sdb” and “distr
by one. To rest
estore Databas estore as datab
files (*.bak) fo
e,
estore Databas estore as datab
down list, selec n list, select th
hot of your data nd the time yo
cheduling infor
he replication c
restore a user d ibution” databa
tore any of the
se]
base] drop dow
or the database
se]
base] drop dow
ct the database e snapshot of
abase at any p ou did your las
rmation or you
components of
database. For ase, please vis
ese databases,
wn list
e to be restore
wn list
e to be restore the database y
point of the tim t subsequent b
u want
This chap vii. Backup/
pter will describ you can restor
Requirem
i. OBM m ii. Data fro
they are comput
you backup file your backup f ess the [OK] b base(s) restor /Restore Lotus be in details ho re your Lotus D
ments
ust be installed om Lotus Dom
e sent to Offsit ter to store the
Domino server up transaction nsure that all d in subdirector om the Domin the "Use Direc ick Server Con ick the Transac omplete these
eld
ansactional Lo og path
aximum log sp
se all available pace on log dev
utomatic fixup
es (*.bak) are files by pressin button red successfully s Domino / Not
ow to use OBM Domino server
d onto the com ino server / No te Backup Serv ese data when
must runs with logging in arch atabases to be ries.
o Administrato ctory on" field, nfiguration, and ctional Logging fields, and the
Enter gging Choos Path n The de data d to sto as a R level 0 The se space device
"Use a ace The m Defau Domin depen
vice Choos y Ye of Choos
not in the def g the [Propert
y tes
M to backup yo / Notes client
mputer running otes client will ver. Please ma you run the ba
h archive trans hive style, plea e logged reside
or, click the Co , choose the se d then click Cu g tab.
n save the doc
se Enabled. The name location o efault path nam directory, altho
re the log on a RAID (Redunda 0 or 1 device w eparate device for the transa e solely for sto all available sp maximum size, lt is 192MB. M no formats at l nding on the m se one:
es to use all av he transaction
se a separate d g. If you choos alue in the "Ma o to use the de Maximum log s se one:
ault directory, ies] button.
our Lotus Domi 5 / 6 / 6.5 fro
Lotus Domino be backed up ke sure you ha ackup job.
saction logging ase do the follo e in the Domino
nfiguration tab erver's Domino rrent Server D
cument.
e default is Dis of the transact me is \LOGDIR ough it is stron a separate, mir ant Array of Ind with a dedicate
should have a ction log. If yo ring the transa ace on log dev in MB, for the aximum is 409 east 3 and up aximum log sp
vailable space o log. This is rec device dedicate se Yes, you do aximum log spa
efault or specif space" field.
you need to u
no server / No m the backup
o server / Note to a temporary ave sufficient d
enabled owing:
o data director
b.
o Directory.
Document.
sabled.
tion log.
R in the Domino gly recommen rrored device, s dependent Disk d controller.
at least 1GB of ou are using th action log, set t vice" field to Ye transaction log 96MB (4GB).
to 64 log files, pace you alloca
on the device f commended if y
ed to storing th on’t need to en
ace" field.
fied value in th
pdate the full
otes client 5 / 6 files.
s client.
y directory bef disk space on y
ry, either at th
o ded
10.6 O
rrupt database
untime / Resta erformance
ogging style es:
can only run t ng archive mod rchive mode o eive an error m
w
Lotus Domino s Pre-Command ackup type to file(s) / datab ackup set
e notes.ini file, nly filled log ex otified of their a
mino server on nly filled log ex otified of their a
Post-Comman
transaction log de. This comma
r if transaction message.
server / Notes ds of this backu
run is [Databa base(s) selecte
, if selected, w xtents will be co
availability for nly) If the back xtents will be co
availability for ds of this back
nabled (default omino cannot ecover it, Domi new DBIID, an new database isabled. Domin utomatically an un the Fixup ta orrupt logged d
eld controls ho ery checkpoint s server perfor cord a recovery active logged d actions would b ase after a sys etes this evalu reates a recove ansaction log, he starting poin ecovery
orces database hey have not b se one:
tandard (defau heckpoints occ avor runtime. D heckpoints, wh esources and im
erformance.
avor restart rec more checkpoin
ecovery time be equired for reco se Archive. The
backup if you and does not a n logging is not
client by takin up set ase Backup typ ed are copied to
will be copied to opied to the te reuse (for Dom kup type to run
opied to the te reuse kup set
t). If a databas use the transa ino runs the Fix nd notifies the
backup is requ no does not run nd notifies the
sk with the -J databases.
ow often Domin in the transac rmance.
y checkpoint, D database to det be necessary to stem failure. W uation, it:
ery checkpoint listing each op nt transaction n e changes to be een saved alre ult and recomm cur regularly.
Domino record hich requires fe mproves serve covery time. D ts, which impr ecause fewer t overy.
e default is Circ
have transact apply if you hav
t enabled at all
g the following
pe],
o the temporar
o the temporar emporary direc mino server on n is [Transactio emporary direc
se is corrupt an ction log to xup task, assig administrator uired.
n the Fixup tas administrator parameter on
no records a ction log, which Domino evalua
termine how m o recover each When Domino
t record in the pen database a
needed for e saved to disk eady
mended).
s fewer ewer system
r run time Domino records
oves restart transactions ar
cular.
tion logging en ve transaction l. If you try to
g steps:
ry directory sp
ry directory tory, and the D logging enable issue it, you w
ecified by this
Domino server
type], Domino server
are ed not will
is
is