Change Sqlvdi.dll IdentifySQLServer
Feb 28, 2007
I've inherited a SQL 2005 Server with SP2 installed that throws this error whenever it's backed up via EMC Insignia's Retrospect 7.5:
Source: SQLVDI
Event ID: 1
SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$DATALIBRARY1. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=4788. Thread=4672. Client. Instance=DATALIBRARY1. VD=.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
---------------
As far as I can tell, the name should be DATALIBRARY, not DATALIBRARY1. Is there a way to change that reference without having to uninstall / reinstall?
Thanks,
- Al
View 5 Replies
ADVERTISEMENT
Mar 23, 2007
I wanted to prevent ntbackup from locking my databases during the nightly backup, so I excluded the ...Data folder from the backup set. However, I think that ntbackup is backing up the databases during the volume shadow copy phase of the backup, even though their folder was excluded from the backup set (I verified this setting in the .bks file). Although the lock only lasts a few seconds, the error message is worrisome and I would prefer to skip the databases completely. How can I stop the volume shadow copy from doing this?
Below is the the sequence of events leading up to the error, most recent first:
Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date: 3/23/2007
Time: 3:01:49 AM
Description:
SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller.
. Process=8684. Thread=7556. Client. Instance=. VD=.
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 18264
Date: 3/23/2007
Time: 3:01:48 AM
Description:
Database backed up. Database: master, creation date(time): 2007/03/12(15:08:23), pages dumped: 1, first LSN: 268:352:37, last LSN: 269:24:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{66DC3082-FB76-4312-AD74-4BDAD9FC7209}1'}). This is an informational message only. No user action is required.
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 3198
Date: 3/23/2007
Time: 3:01:47 AM
Description:
I/O was resumed on database master. No user action is required.
Event Type: Information
Event Source: ESENT
Event Category: ShadowCopy
Event ID: 2003
Date: 3/23/2007
Time: 3:01:47 AM
Description:
lsass (956) Shadow copy 24 freeze stopped.
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 3197
Date: 3/23/2007
Time: 3:01:45 AM
Description:
I/O is frozen on database master. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
Event Type: Information
Event Source: ESENT
Event Category: ShadowCopy
Event ID: 2001
Date: 3/23/2007
Time: 3:01:45 AM
Description:
lsass (956) Shadow copy 24 freeze started.
Event Type: Information
Event Source: NTBackup
Event Category: None
Event ID: 8018
Date: 3/23/2007
Time: 3:00:14 AM
Description:
Begin Operation
View 43 Replies
View Related
Apr 23, 2008
One of our server administrators was told by a software supplier that we needed the above .dll (the exact version specified) to get a shadowcopy program to work (??!!). Anyway, there is a SQL 2005 hotfix that you can request which says that it contains this dll (SQLServer2005-KB936305-x86-ENU). I unpacked it, but couldnt find the correct version in any of the cabs, so I set up a vanilla SQL 2005 install, service packed it and added this hot fix - guess what? the dll is there, but version 2000.85.2004.0.
I am at the end of my tether - can someone point me to a download location where I can get this file please?
Many thanks
View 3 Replies
View Related
May 12, 2015
Trying to determine what the minimum permissions i can grant to a user so they can see the change tracking data
View 1 Replies
View Related
Nov 18, 2015
We ran into weird/interesting issue with below details.
Version: Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200):
We are using SQLCMD to run DDL script on our product database in below order. That script has below content.
step # 1 - database collation change (case -sensitive) statement as very first statement of the script
step # 2 - Actual DDL SQL statements
step # 3 - database collation change back to original (case insensitive)
When we execute all above 3 steps in single script using SQLCMD on our test_server#1 , it is successful but when same is being implemented on test_ server#2 , it is failing.We ensured that there is no other user accessing the db and setting on both the server are all default/basic. Separating out all 3 steps in 3 different script working fine. This is only problem when we combine them into single script and fire it using SQLCMD. If it is something related to session/transaction then we should hit same issue on our test_server#1 server as well but that is not the case.test_server#1 and test_server#2 has exact same database/data, just two different physical machine & SQL Server instance.
View 7 Replies
View Related
Apr 24, 2001
can you change the dbo after you've already made the database?
View 1 Replies
View Related
Jun 20, 2002
Hi:
Actually i'm working with a pc named "my_pc", later i'll need to change
its name to "my_server". Obviously MsSQLServer is afected due to it depends
in the name of the pc, also the master database has all its configurations
and aditional information related to the name "my_pc".
My question is: How can i do the change in MsSQLServer without
reconstruncting the master database?
Thanks in advance.
View 1 Replies
View Related
Oct 15, 2004
Hi
This code is for Access db
strSQL = "SELECT TOP 20 tblThread.Topic_ID, Subject, Username, tblThread.Thread_ID, Message, Message_date "
strSQL = strSQL & "from tblTopic, tblThread, tblAuthor "
strSQL = strSQL & "where tblThread.Topic_ID = tblTopic.Topic_ID "
strSQL = strSQL & "and tblThread.Author_ID = tblAuthor.Author_ID "
strSQL = strSQL & "order by Message_date DESC"
can you rewrite it for SQL Db
with this
strSQL = EXECUTE
thanks
View 3 Replies
View Related
Jan 18, 2005
Hi,
Can anyone help me on this problem please?
When i use sql statement to pull out data, one of the fields will pull out data like 200 or 300 or sumthing like that.
But now i need to pull out the data as 2.00 instead of 200.
How do i do that?
Thanx
View 2 Replies
View Related
Sep 24, 2007
HI Everyboody,
How can i change SYSTEM ADMINISTORS NAME plz explain me
cureent my system admin name is 'bindu' it will rename 'RENU' How plz explain me
Thx
Meti BEST OF THE BEST
View 6 Replies
View Related
Mar 8, 2007
i set the name of my ss to default on install, and now i want to use 'AttachDbFilename' to attach my dbfile in my asp.net app, but i cannot connect to the server. i fond in the adv. options, that the DataSource is set to '.SQLEXPRESS' which is not the name of my SS, but i can't change it, so i want to ask if i can change the name of my SS withou reinstall.
thx for helping!
View 5 Replies
View Related
Sep 13, 2007
I have a web app, designed using VWD Express and using SQL 2005 Express. It has a mdf database called "client". It was created using security of windows authentication. I have already changed my instance of sql server express to accept mixed windows and sql authentication.
How do I change my "client" database's permissions to the sql authentication? I need to add a user name and password as a requirement for my web host to be able to attach the mdf to their instance of sql 2005. It has to be the same user and password as I use with my web host's sql server 2005.
Thank you in advance.
View 2 Replies
View Related
Oct 29, 2007
Hi All,
Suppose I have created one table say "Customer"
Customer (cust_no, cust_name,cust_address)
I want to change the attribute name "cust_no" to "cust_number".
How to do it using ALTER command.
Pls give me the exact syntax for this.
Regards
Abdul
View 1 Replies
View Related
Nov 30, 2007
When I try to execute a query and after 30 seconds the program sends me error :
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Exception Detail: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Source error:
Line 550 Dim myDataSet as Dataset = New DataSet
Line 551 myDataSet = db.ExecuteDataSet(System.Data.CommanType.Text,NewSql) <== Error line
Line 552 i=myDataSet.Tables(0).Rows.Count
In my connection string I set the parameter "Connection Timeout" = 360 but it not works. ( In debug mode the value for db.GetConnection.ConnectionTimeout is the same(360) like the parameter timeout connection.
After many searchs I found the default value for CommandTimeout is 30 secs. Can I change this value ?
Any suggestion will be welcome.
I'm using FrameWork 1.1.
View 3 Replies
View Related
Apr 24, 2006
I was simply trying to create a sql command using ASP 2.0 but the syntax appears to have changed. I was trying to write the following:
SqlCommand cmdUpdateData = new SqlCommand("AddMessage", myConnection);
cmdUpdateData.CommandType = CommandType.StoredProcedure;
But, intellisence will not offer me the second 'CommandType' on the second line?? It works fine using ASP 1.1 but not here on 2.0
Can anyone please help?
View 7 Replies
View Related
Aug 6, 2002
hi,
I just imported my access database into sql server 2000 and apparently during this importation the owner was set to my name. This gives my a problem retrieving the data in asp.net though. I found out that the problem (System.Data.SqlClient.SqlException: Invalid object name 'tablename') is situated at this ownership by stripping the query to a bare minimum and trying it on a new table created in sql server with dbo as the owner.
My problem now is that I can't seem to find the way to change the owner to dbo from 'peterj'. Can you help me on this one ??
View 1 Replies
View Related
Apr 20, 2001
I have one server out of 6 that lets me logon as SA with the default password
of null.
If I run this command to change the password I get password changed, but it
did not change it, I still can logon as SA with the NULL password.
exec sp_password NULL, abc123, 'sa'
View 2 Replies
View Related
May 30, 2001
I have take courses in VB 6.0 and SQL 2000.
My background is accounting and financal analysis. I would like to change my career to the IT field and be in a position to use my financial background to my advantage. any suggestions?
View 2 Replies
View Related
Jun 24, 2001
hello..
how can i change the login name ( sa)
to login name saliman?
View 1 Replies
View Related
Jul 2, 2001
I have a few ASPs that were written to pull from an Access 97 database. Now that we have converted the data over to a SQL database, the ASPs have been changed accordingly. My problem is that I have two ASPs which use an Inner Join between three tables where the main field (in this case it is called "INDEX") is what the pull is based on. When I try to run the ASPs I recieve this error .
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'INDEX'.
The line that it identifies is where the connection is actually opened.
This is only occuring on the ASPs that use the column INDEX and an inner join. The straight style number pulls (which have the same connection string)
are working fine. Any ideas?
View 1 Replies
View Related
Jul 5, 2001
Is there a way in SS 7.0 to change ownership of an object from a user owned object to dbo owned object other than dropping the object and re-creating it? E.G. juser.table to dbo.table
Thank you,
GaetonC
View 2 Replies
View Related
Aug 6, 2001
We need to test a DTS package provided by a vendor. The DTS package imports data from flat files to a database. However, when I go in and change the DTS connection object for the database, it drops the data transformation properties. When I look at the properties it automatically points to the first (alphabetically speaking) table of our database. There is no way for me to verify that the mapping I am creating for these tables is accurate (and matches what the vendor had originally set). I am new to MS SQL and haven't found the answer ... any help would be appreciated!
Thanks!
View 2 Replies
View Related
Nov 22, 2000
Can you easily change the character set during a 6.5 to 7.0 upgrade using the SQL upgrade wizard? Or do you have to rebuild master etc?
Thanks
JD
View 1 Replies
View Related
May 4, 2000
The old administrator left and I am learning slowly. Since his password was changed, SQL cannot start. I get an error 1069 login failed. Maybe you have a good idead I haven't thought of?
View 1 Replies
View Related
Aug 2, 2000
Hello,
I need to change server name on my WinNT Server. But if I change the server name on NT Server, SqlServer does not connect. Can I change registered server name on SQLServer ? What do I need to do ?
Thank you.
Hugo Venturini
View 1 Replies
View Related
Jul 26, 2000
I have tables created by a user called "toms". He has dbo permission etc.
I want to make all these tables to be owned by sa ( dbo). How do I do that?
the owner of the database is sa
thanks,
Rachel
View 1 Replies
View Related
Sep 14, 2000
Does anyone know how to change the database owner to sa (dbo)?
View 2 Replies
View Related
Jan 17, 2001
Hi all,
There is a guy in my company install a sql server himself, but he picked the per seat license rather then the per server (we got the per server license), is there a way to change it without re-install the whole sql server? or need to reinstall from start?
Thanks,
Westley
View 1 Replies
View Related
Dec 7, 2000
Hi,
If I change the name of the NT server, mssqlserver NT service does not start up.
Is there a way around this? URGENT.
View 1 Replies
View Related
Mar 30, 2000
1. How could I change the Domain within SQL Server.
2. When the NT Server changed to a new domain, Does the SQL server change also? Could someone help me. Thank you.
View 2 Replies
View Related
Oct 28, 1999
I tried changing the character set of my database..transfering it btw two servers, first one with codepage850 and the second one with iso. As I expected the characters where not automatically transformed and I got some accents that are wrong.
Could anyone telle me how to transform this...do I need a filter or something ?
I'm using SQL 7.0...
Thanks for your help,
--Eric
View 3 Replies
View Related
Nov 4, 1999
How Can I change table's owner
View 2 Replies
View Related
Mar 9, 2001
How do you change the ownership of a DTS package?
View 1 Replies
View Related
