Re: Backup of MSSQL Databases
2006-05-03 12:15:46
We use the native MSSQL backup utility and back them up to a remote
archive server and archive all MSSQL dbs from a single location.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Ung Yi
Sent: Wednesday, May 03, 2006 11:05 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Backup of MSSQL Databases
Hello,
We backup the databases to local drives then have TSM pick the backup
files.
Yi
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Victoria Ortepio
Sent: Wednesday, May 03, 2006 12:02 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Backup of MSSQL Databases
We need to back up MSSQL databases, but they need to be closed to the
RDMS
first. Has anyone done that? We do not have the Tivoli TDP agent, nor
any other
agents that handle open database files. I am not the best script
writer, but I was
thinking to build a script somewhat like the following:
preschedulecmd detach-script
cd \Program Files\Tivoli\TSM\baclient
dsmc selective -Filelist=f:\mssql\jobs\DBs.txt >
f:\mssql\log\DB-%1-bkup.log
postschedulecmd attach-script
detach-script:
exec sp_detach_db 'dbname1' 'true'
go
exec sp_detach_db 'dbname2' 'true'
go
attach-script:
exec sp_attach_db 'dbname1'
go
exec sp_attach_db 'dbname2'
go
Thanks!
Vicki
Verizon Business
|
|
|