TSM for SQL 5.5.2.0 Exclude offline Database

[interface]

Hi guys,

I'm having a problem with backing up my SQL databases. I turned 1 database offline and now it keeps giving errors ( return code 402 ). It's a Windows 2000 machine ( I know it's old ) with the 5.5.2.0 Client installed on it.

Does anyone know how to exclude a offline database through the OPT-file ?

Thanks in advance.

 

[zsoltesz]

Hi,

I think, you use the command like this: tdpsqlc backup * full ....

In the syntax of the tdpsqlc command there is e new parameter: /excludedb. Using this paramater you can exclude the offile database from the backup.

Zoli

 

[interface]

Hi Zoli,

I found that command, but in that case I need to set every database in the tdpsqlc command. I prefer to set it in the OPT file like : tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt

 

[zsoltesz]

In the .opt file you can use the exclude/include statements. For exapmle, exlude \...\database_name\...\*

Zoli

 

[interface]

Forgot to mention....

I tried this :

EXCLUDE \...\CREFO\...\*

and this :

EXCLUDE \...\meta\...\CREFO\...\*

Both no success.

 

[Trident]

You need to use tdpsqlc backup * full /excludedb=DBName

 

[interface]

Thnx for the reply Trident.

Now I get another failure : "ANR2579E - Return Code 1204" so that is not working....

 

[Trident]

I think your are stuck between a rock and a mountain. excludedb came on a later release.

If your number of db's are low, then

tdpsqlc backup db1,db2...dbX full

is probably the only choice, unless you can upgrade your client.

 

[interface]

It's our old SQL server and there are just a few databases on it, so I used your suggestion and that worked. Thanks !