ADSM-L

Re: Backup of MSSQL Databases

2006-05-03 12:19:13
Subject: Re: Backup of MSSQL Databases
From: Victoria Ortepio <victoria.ortepio AT VERIZONBUSINESS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 3 May 2006 12:13:20 -0400
That's what we current do.  But we have been having space issues with
the database sizes being backed up.

Vicki

-----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 12:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] 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

<Prev in Thread] Current Thread [Next in Thread>