Database is offline

[Daemon-FF]

I've installed TSM server 6.3.4.300 (on windows platform) and (on another windows box) TSM BA Client 7.1.0.2 and TDP for MSSQL 7.1.0.0.

Now I cannot backup any database from MSSQL 2012 with command line interface: when I run command 'tdpsqlc.exe backup MyDB full /BACKUPMETHod=VSS', I receive error message: 'ACO5958W The selected database <MyDB> is offline -- skipping.'. This happens with any database - model, model, msdb. But databases is ONLINE, I'm sure!

When I use TDP MMC console, VSS backups those DBs are successful:

03/28/2014 10:09:11 ============================================================
03/28/2014 10:09:11 Request : VSS BACKUP
03/28/2014 10:09:11 Component List : 'MyDB'
03/28/2014 10:09:11 Backup Type : full
03/28/2014 10:09:11 Backup Destination : TSM
03/28/2014 10:09:11 Local DSMAGENT Node : SC12R2
03/28/2014 10:09:11 Offload to Remote DSMAGENT Node :
03/28/2014 10:09:11 Mount Wait : Yes
03/28/2014 10:09:11 ------------------------------------------------------------
03/28/2014 10:09:14 Server : 192.168.6.38
03/28/2014 10:09:14 ------------------------------------------------------------
03/28/2014 10:10:05 VSS Backup operation completed with rc = 0
03/28/2014 10:10:05 Files Examined : 5
03/28/2014 10:10:05 Files Completed : 5
03/28/2014 10:10:05 Files Failed : 0
03/28/2014 10:10:05 Files Deduplicated : 0
03/28/2014 10:10:05 Total Bytes Inspected : 78212854
03/28/2014 10:10:05 Total Bytes : 29154854
03/28/2014 10:10:05 Total LanFree Bytes : 0
03/28/2014 10:10:05 Total Bytes Before Deduplication : 0
03/28/2014 10:10:05 Total Bytes After Deduplication : 0
03/28/2014 10:10:05 Files Compressed By : 63%
03/28/2014 10:10:05 Deduplication Reduction : 0,00%
03/28/2014 10:10:05 Total Data Reduction Ratio : 62,73%


Backup with method 'LEGACY' is successful in any case - command line or TDP MMC console.

My environment: Windows Server 2012R2, MSSQL 2012, TSM server 6.3.4.300, TSM BA Client 7.1.0.2, TDP for MSSQL 7.1.0.0

Anybody can help me?

With regards, Serge.

 

[Daemon-FF]

I think the problem is here:

----------------

C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc.exe q sql
ANS0102W Unable to open the message repository tdpsrus.txt. The American English repository will be used instead.

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 7, Release 1, Level 0.0
(C) Copyright IBM Corporation 1997, 2013. All rights reserved.

Connecting to SQL Server, please wait...

SQL Server Information
----------------------

SQL Server Name ........................ SC12R2\SQL4SC2012R2
SQL Server Version ....................... 11.0.3000 (SQL Server 2012)


Volume Shadow Copy Service (VSS) Information
--------------------------------------------

Writer Name : SqlServerWriter
Local DSMAgent Node : SC12R2
Remote DSMAgent Node :
Writer Status : Offline
Selectable Components : 0


The operation completed successfully. (rc = 0)

C:\Program Files\Tivoli\TSM\TDPSql>
-----------------------------

Why writer status is OFFLINE?! vssadmin raports that SqlServerWriter is OK, state is stable and last error is no error!

 

[suppcfri]

Our group is experiencing the same issue with our configuration except we're using TSM for Databases 6.4.1 and TSM BAC 6.4.1. The "SQL Server VSS Writer" service is running but when we run "tdpsqlc.exe q sql" we are seeing that the "Writer Status" shows "Offline". Running "vssadmin list writers" shows the SQL writer as being stable and without errors. Running a VSS SQL backup manually via the "DP For SQL Management Console" works fine.

sqlfull.cmd (backup script) contains
rem =========================================================
rem Specify the directory where TDP for SQL is installed
rem and change to that directory.
rem =========================================================
set sql_dir="C:\Program Files\Tivoli\TSM\tdpsql"
cd /d %sql_dir%


rem =========================================================
rem Output the current date and time to three separate log
rem files
rem =========================================================
echo Current date is: >> sqlsched.log
date /t < NUL >> sqlsched.log
echo Current date is: >> sqlfull.log
date /t < NUL >> sqlfull.log
echo Current time is: >> sqlfull.log
time /t < NUL >> sqlfull.log


rem =========================================================
rem Start Backup
rem
rem =========================================================
tdpsqlc backup * full /logfile=sqlfull.log >> sqlsched.log


sqlfull.log shows
04/02/2014 22:10:27 ACO5958W The selected database <*> is offline -- skipping.
04/02/2014 22:10:27 ACO5204E One or more of the specified databases do not exist or are unavailable for backup.

 

[syntax44]

Despite the fact that "vssadmin list writers" show the SqlServerWriter as being online, try rebooting the system or restarting the VSS service. If that does not work, most likely you'll need to speak with your Microsoft/Windows platform administrator.

But before you do any of that, it might be worth to have a look at this link: "Verifying VSS functionality for the Data Protection SQL backup": http://www-01.ibm.com/support/docview.wss?uid=swg21403458. If that all works, and your SQL backup is still failing....Also try to find clues in your local Windows Event Log.

 

[[email protected]]

Backup with method 'LEGACY' is successful in any case - command line or TDP MMC console.

My environment: Windows Server 2012R2, MSSQL 2012, TSM server 6.3.4.300, TSM BA Client 7.1.0.2, TDP for MSSQL 7.1.0.0

Anybody can help me?

With regards, Serge.

Hi Serge - How you managed to install tdp for mssql 7.1.0 on windows 2012 r2. For me its saying app is not supported or am i using the wrong binaries. Can you provide me the link from where you downloaded the client?

Thanks
Salil