Jump to content
allisong

Re: SQLVDI error in event log at time of SQL backup

Recommended Posts

Same error here, needs to be solved:

 

Event Type: Error

Event Source: SQLVDI

Event Category: None

Event ID: 1

Date: 02/04/2008

Time: 00:54:57

User: N/A

Computer:

Description:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$. ErrorCode=(1060)The specified service does not exist as an installed service. Process=2916. Thread=1388. Client. Instance=. VD=.

Edited by Guest
Hijacking posts is not allowed. Created new thread

Share this post


Link to post
Share on other sites

This is a Microsoft VDI error 1060 and not a Retrospect error. Do you get any errors in the Retrospect operations log?

 

What version of Retrospect are you using?

What version of SQL?

Is the SQL Server a client or local to the backup server?

Share this post


Link to post
Share on other sites

I am using Retrospect 7.5.508 with 7.5.13.100 hotfixes.

 

I am using SQL server 2005 standard.

 

The SQL server is on the same machine as Retrospect and is being backed up to tape locally. The messages I get are:

 

Event Type: Error

Event Source: SQLVDI

Event Category: None

Event ID: 1

Date: 24/04/2008

Time: 12:07:20

User: N/A

Computer:

Description:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$. ErrorCode=(1060)The specified service does not exist as an installed service.

. Process=7484. Thread=5212. Client. Instance=. VD=.

 

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.'>http://go.microsoft.com/fwlink/events.asp.

 

 

Then I get:

 

Event Type: Information

Event Source: MSSQLSERVER

Event Category: (6)

Event ID: 18264

Date: 24/04/2008

Time: 12:07:36

User:

Computer:

Description:

Database backed up. Database: master, creation date(time): 2008/04/22(20:01:41), pages dumped: 387, first LSN: 235:272:50, last LSN: 235:304:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'dantz_retrospect_vd_master'}). This is an informational message only. No user action is required.

 

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

 

So this suggests it backups ok but that Retrospect causes the error by querying something via SQLVDI wrongly, so I don't think Retrospect can be blameless as this does not happen with other backup packages!!!

Share this post


Link to post
Share on other sites

What does the Retrospect operations log report? Is Retrospect getting a specific error?

 

In the case of the 2nd message, it clearly says "This is an informational message only. No user action is required."

Share this post


Link to post
Share on other sites

Our engineers have reproduced the problem with errors being displayed in the event logs and we have logged a bug for it.

Share this post


Link to post
Share on other sites

We are also having this problem. After spending a week trying to get SQL backup working it is really annoying to have to deal with possibly bogus application log errors daily. Does this error mean there is a problem with my SQL backups or is it a benign error?

Share this post


Link to post
Share on other sites

We have fixed a cosmetic bug that can cause the Event logs to display some bogus data. The fix will be released in a week or two.

Share this post


Link to post
Share on other sites

Windows Server 2003

Multi Server v7.6.123

SQL Server 2005 on Win2k3

 

Though the Retrospect log says "Execution completed successfully" for several database backups, the server hosting SQL Server has many correlated error messages such as:

 

Event Type: Error

Event Source: SQLVDI

Event Category: None

Event ID: 1

Date: 2/11/2009

Time: 10:43:47 PM

User: N/A

Computer:

Description:

SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$(local). ErrorCode=(1060)The specified service does not exist as an installed service.

. Process=308. Thread=320. Client. Instance=(local). VD=.

 

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.'>http://go.microsoft.com/fwlink/events.asp.

 

 

Event Type: Information

Event Source: MSSQLSERVER

Event Category: (6)

Event ID: 17055

Date: 2/11/2009

Time: 10:43:50 PM

User:

Computer:

Description:

18264 :

Database backed up: Database: , creation date(time): 2005/03/31(10:39:57), pages dumped: 3155, first LSN: 998:3981:1, last LSN: 998:3983:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'dantz_retrospect_vd_'}).

 

 

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 58 47 00 00 0a 00 00 00 XG......

0008: 0d 00 00 00 47 00 45 00 ....G.E.

0010: 4e 00 4f 00 4d 00 45 00 N.O.M.E.

0018: 2d 00 50 00 4c 00 55 00 -.P.L.U.

0020: 54 00 4f 00 00 00 09 00 T.O.....

0028: 00 00 4b 00 44 00 42 00 ..K.D.B.

0030: 5f 00 56 00 42 00 52 00 _.V.B.R.

0038: 43 00 00 00 C...

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×