TDP for SQL - with many databases - some of them in simple

enojado

ADSM.ORG Member
Joined
Jan 6, 2009
Messages
22
Reaction score
0
Points
0
PREDATAR Control23

Hi,


We use sqlfull.cmd to take full backup once a day with a few log backups. We have a problem when a ms sql instance has hundreds of databases. Some databases have status: simple. This means that the log backup fails and makes a lot of noise in the reporting system.

Is it possible to drop log backup to take a full backup of databases which have status: simple, or new created databases with missing full backup?


Thanks!
 
PREDATAR Control23

Please double check if the recovery mode on the tables is being set to simple (change the recovery mode to Full if it doesn't) and double check the backup option that the 'Truncate' value has been set to True. Logs backup sometime fail because of the DB has 'Truncate log on checkpoint' which mean simple recovery mode.
 
PREDATAR Control23

Perhaps you can make a smarter backup script that first queries the MS SQL server to check which DB's should have a backup.
sqlfull.cmd delivered with TSM is using a wildcard (*) if I remember correctly
 
PREDATAR Control23

code

Thank you.
Here is some of the standard script im using.
I want to change the script so that logonly function runs full backups if tsm says that full backup does not exist or have status simple..


Code:
setlocal

if "%1"=="dbonly" (
  set dbonly=Y
  shift
) else (
  set dbonly=N
)
if "%1"=="logonly" (
  set logonly=Y
  shift
) 

if "%1"=="" (
       SET DB=*
) else (
       SET DB=%1
)
 
Top