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:[EMAIL PROTECTED] On Behalf Of Ung Yi Sent: Wednesday, May 03, 2006 11:05 AM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of Victoria Ortepio Sent: Wednesday, May 03, 2006 12:02 PM To: ADSM-L@VM.MARIST.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
