SQL Server backup issues

[kythri]

I'm getting the following error now on one of my SQL boxes:

Unsuccessful savesets
* nss-c1a:MSSQL: 5 retries attempted
* nss-c1a:MSSQL: No full backups of this save set were found in the media database; performing a full backup
* nss-c1a:MSSQL: Error detecting SVS logon name for nss-c1a.mmc-sil.com
* nss-c1a:MSSQL: Microsoft SQL Server Provider error:
* nss-c1a:MSSQL: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
* nss-c1a:MSSQL: [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen [Connect[]].
* nss-c1a:MSSQL:
* nss-c1a:MSSQL: Cannot login to SQL Server null.

What did I forget to do here?

 

[eskolnik]

Hey perfect timing!
I have this problem too NW 6.1.3 NMSQL 3.1.1.32

MSSQL$UMCOMPASS:: No full backups of this save set were found in the media database; performing a full backup
* um00cmp0:MSSQL$UMCOMPASS: rcmd um00cmp0, user root: `nsrsqlsv -s chi-backup -g skolnik1 -LL -f - -m um00cmp0 -l full -v -W 78 -N MSSQL$UMCOMPASS: MSSQL$UMCOMPASS:'
* um00cmp0:MSSQL$UMCOMPASS: Backing up HWProduction...
* um00cmp0:MSSQL$UMCOMPASS: Error loading VDI.DLL. Class not registered
* um00cmp0:MSSQL$UMCOMPASS:

http://support.microsoft.com/default.aspx?scid=kb;en-us;217118

Ed Skolnik

 

[eskolnik]

Help??? Ed Skolnik

 

[x2shy]

The first errror (kythri)sounds like a security issue.
If you don't specify a username and password for the SQL database then it will try and use the default SQL one.
Try putting the username and password for the SQL db under the remote tab on the client setup.

The second one sounds more like an SQL problem.
Can you do a manual backup? Can you dump to a flat file from SQL?
That's what I would do.

hope it helps.
I'm NOT an SQL dba so I may have no idea what I'm talk ing about.

 

[disldrautoldmc]

Start legato service (nsrexecd) with the same user that the SQL services starts.
You are sure now that you have the right permission to open/access database.

If the problem persist try to reapply the service pack for SQL.

Bye.

 

[eskolnik]

_____ A fix That really works _____________________




Ed,

Check the version of the sqlvdi.dll file as instructed below and then follow the instructins to register it. If you are still having problems then please send the nsrsqlsv.log from the SQL client and the messages file from the backup server.

1-PRODUCT SIZE MOD DATE CAB/IEXPRESS RELATIVE PATH
Small Business Server 2000 45,133 8/6/2000 \cd2\sql2000\x86\binn
SQL Server 2000 Developer Edition 45,133 8/6/2000 \x86\binn
SQL Server 2000 Enterprise Edition 45,133 8/6/2000 \x86\binn
SQL Server 2000 Personal Edition 45,133 8/6/2000 \x86\binn
SQL Server 2000 Standard Edition 45,133 8/6/2000 \x86\binn

For above SQL product ,sqlvdi.dll file version should be . 2000.80.194.0

2-PRODUCT SIZE MOD DATE CAB/IEXPRESS RELATIVE PATH
SQL Server 7.0 SP2 98,304 2/8/2000 \binn

For above SQL product,sqlvdi.dll file version should be . 2000.2.8.0

3-PRODUCT SIZE MOD DATE CAB/IEXPRESS RELATIVE PATH
SQL Server 7.0 SP1 94,208 4/12/1999 \x86\x86\binn
For above SQL product,sqlvdi.dll file version should be . 1999.4.12.0

4-PRODUCT SIZE MOD DATE CAB/IEXPRESS RELATIVE PATH
Office 2000 SR1 90,112 11/13/1998 \premium\retail\cd3\sql\x86\binn
SQL Server 7.0 90,112 11/12/1998 \x86\binn
SQL Server included with BackOffice 4.5 90,112 11/13/1998 \x86\binn
For above SQL product,sqlvdi.dll file version should be . 1998.11.13.0

Solution #1
If sqlvdi.dll version is wrong, need to contact microsoft for right sqlvdi.dll

Solution#2
If sqlvdi.dll version is right and getting error above mention error message.
***********************************
Need to re-register sqlvdi.dll

Steps to register sqlvdi.dll
1. Click the start button, and then click Run
2. In the Open box, type the following:
3. Regsvr32 (path to sqlvdi.dll) where (path to sqlvdi.dll) is the actual path to the SP2 version of the dll


Ed Skolnik