Creating VirtualDeviceSet for Remote SQL Server 2005 failed.

Hi, all!

I am writing the VDI application to allow backup/restore MS SQL Server 2005. I would want to backup/restore remote servers as well as local. I have local instance of MS SQL 2005 and remote. Local instance has MSSQL2005_ZORG instance name, remote uses default (so it supposed to be MSSQLSERVER).

While connection to those server via SQL Server Management studio i see local server as "ZORG\MSSQL2005_ZORG" and remote as "VM2000SRVZ2".

When i try to create VIrtualDeviceSet via CreateEx i pass "MSSQL2005_ZORG" as lpInstanceName parameter and all works fine. But I could't create same device set for remote 'MSSQLSERVER' instance. I passed any combination for that, such as "VM2000SRVZ2\MSSQLSERVER", "MSSQLSERVER", "VM2000SRVZ2", "\\VM2000SRVZ2\MSSQLSERVER" and so on. No luck always get VD_E_INSTANCE_NAME (0x80770007).

Any idea?

--Thanks

Hi,
As per the Microsoft Virtual Backup specifications, VDI can be used only on local machines.You can download the specifications from

http://www.microsoft.com/downloads/details.aspx?familyid=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&displaylang=en

If u have used VDI for some time, i need ur help.Relpy if you can

Creating VirtualDeviceSet for Remote SQL Server 2005 failed.

Hi, all!

I am writing the VDI application to allow backup/restore MS SQL Server 2005. I would want to backup/restore remote servers as well as local. I have local instance of MS SQL 2005 and remote. Local instance has MSSQL2005_ZORG instance name, remote uses default (so it supposed to be MSSQLSERVER).

While connection to those server via SQL Server Management studio i see local server as "ZORG\MSSQL2005_ZORG" and remote as "VM2000SRVZ2".

When i try to create VIrtualDeviceSet via CreateEx i pass "MSSQL2005_ZORG" as lpInstanceName parameter and all works fine. But I could't create same device set for remote 'MSSQLSERVER' instance. I passed any combination for that, such as "VM2000SRVZ2\MSSQLSERVER", "MSSQLSERVER", "VM2000SRVZ2", "\\VM2000SRVZ2\MSSQLSERVER" and so on. No luck always get VD_E_INSTANCE_NAME (0x80770007).

Any idea?

--Thanks

Hi,
As per the Microsoft Virtual Backup specifications, VDI can be used only on local machines.You can download the specifications from

http://www.microsoft.com/downloads/details.aspx?familyid=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&displaylang=en

If u have used VDI for some time, i need ur help.Relpy if you can

creating tables in Linked servers.

How do i create a table on an linked server. The table that i want to create
is an # table.
A # table is a temporary table and I think that it's only on the local tempdb
you can do it (not sure) as it is link with the current process and it runs
only on the actual server. So you can't do it on a linked server. Hope this
will help.
P.RUELLO
DBA
"RameshR" wrote:

> How do i create a table on an linked server. The table that i want to create
> is an # table.

creating tables in Linked servers.

How do i create a table on an linked server. The table that i want to create
is an # table.A # table is a temporary table and I think that it's only on the local tempd
b
you can do it (not sure) as it is link with the current process and it runs
only on the actual server. So you can't do it on a linked server. Hope this
will help.
--
P.RUELLO
DBA
"RameshR" wrote:

> How do i create a table on an linked server. The table that i want to crea
te
> is an # table.sql

creating tables in Linked servers.

How do i create a table on an linked server. The table that i want to create
is an # table.A # table is a temporary table and I think that it's only on the local tempdb
you can do it (not sure) as it is link with the current process and it runs
only on the actual server. So you can't do it on a linked server. Hope this
will help.
--
P.RUELLO
DBA
"RameshR" wrote:
> How do i create a table on an linked server. The table that i want to create
> is an # table.

Creating schemabound views on linked servers

Hi,
I need to create indexes and use index hints on views created
across two servers (in the linked server model). Assuming that it is
possible to do so, I first need to create an unique clustered index on
the view. This in turn mandates that the underlying view is a
schemabound view that takes only a two part name (dbo.objectname).
However, a view created on a linked server has four parts in its name
(linkedserver_name,db_name,owner_nameobj
ect_name). This causes the sql
parser to reject my request to create a schema bound linked server
view. Can anybody tell me if there is a work around for this?
Thanks
/SudhaAn indexed view cannot store data from a table that resides in another datab
ase or another server...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<srajagop@.genesyslab.com> wrote in message
news:1163034549.484430.255030@.i42g2000cwa.googlegroups.com...
> Hi,
> I need to create indexes and use index hints on views created
> across two servers (in the linked server model). Assuming that it is
> possible to do so, I first need to create an unique clustered index on
> the view. This in turn mandates that the underlying view is a
> schemabound view that takes only a two part name (dbo.objectname).
> However, a view created on a linked server has four parts in its name
> (linkedserver_name,db_name,owner_nameobj
ect_name). This causes the sql
> parser to reject my request to create a schema bound linked server
> view. Can anybody tell me if there is a work around for this?
> Thanks
> /Sudha
>

Creating schemabound views on linked servers

Hi,
I need to create indexes and use index hints on views created
across two servers (in the linked server model). Assuming that it is
possible to do so, I first need to create an unique clustered index on
the view. This in turn mandates that the underlying view is a
schemabound view that takes only a two part name (dbo.objectname).
However, a view created on a linked server has four parts in its name
(linkedserver_name,db_name,owner_nameobject_name). This causes the sql
parser to reject my request to create a schema bound linked server
view. Can anybody tell me if there is a work around for this?
Thanks
/SudhaAn indexed view cannot store data from a table that resides in another database or another server...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<srajagop@.genesyslab.com> wrote in message
news:1163034549.484430.255030@.i42g2000cwa.googlegroups.com...
> Hi,
> I need to create indexes and use index hints on views created
> across two servers (in the linked server model). Assuming that it is
> possible to do so, I first need to create an unique clustered index on
> the view. This in turn mandates that the underlying view is a
> schemabound view that takes only a two part name (dbo.objectname).
> However, a view created on a linked server has four parts in its name
> (linkedserver_name,db_name,owner_nameobject_name). This causes the sql
> parser to reject my request to create a schema bound linked server
> view. Can anybody tell me if there is a work around for this?
> Thanks
> /Sudha
>

Creating Peer-to-Peer Merge Replication

We have a situation exactly like that shown in the documentation for creating a peer-to-peer merge replication. That is, we have three servers, one each in Chicago, New York, and Bermuda. Users in each office will read and write to their respective servers and the servers will then replicate with one another. The documentation, however, only shows how to set up peer-to-peer for a transactional replication. The problem is that the various Manger Studio options and the database stored procedures are NOT the same between transactional and merge replication and on the face of it, merged replication does not support a peer-to-peer topology. Can somebody walk me through the process of creating a peer-to-peer merge replication, or else convince me that I should go with transaction with updating subscriptions -- in contravention of what the documentation seems to reccommend? I'd really appreciate it!

Thanks.

Randy

before any recommendations, what are your business requirements in terms of latency? regarding a merge replication, is there something else you require that prohibits you from doing a standard publication with two subscriptions?|||

In terms of business requirements the only issue is that three distinct set of users, in three different parts of the world, are updaing their own local servers but that update information needs to be reflected on all servers. The way my boss and I read the documentation, the two options are merge or transaction with updatable subscriptions. Between the two options, the documentation seems to encourage peer-to-peer merge replication.

As for latency, we're probably talking less than 50 transactions per second. Indeed, I suspect we are more in the 10 to 20 range. Since we have big pipes and good servers, I don't expect latency to be much of a problem no matter what we do.

Thanks for your input.

Randy

Creating multiple databases running off the same Data Engine

Hi, I have looked and loked for the answer to this question and made no progress.
I want to install MSDE on one of our servers, however, when I went to install it, I found that there was another MSDE already installed and running (it was an agent running with our backup software Veritas). Is it alright to create another database and have 2 running simultaneous on the same data engine? Is there any type of limitations that I sould know about - such as number of allowed accesses at one time? Any help is greatly appreicated.You can create another database with the existing MSDE but if you are on a large network I would install another instance and get the Developer edition to manage them that way you will avoid the risk of running your application on MSDE that is already used to the max in system resources. I have seen SQL Server running without databases because it is used to run xp_cmdshell to move data from DB2 AS400 to live SQL Server on the web about four hours a day. Try the link below to buy the Developer edition. When you have installed the Developer edition you right click at the top of Enterprise manager and register both. Hope this helps.
http://www.provantage.com/buy-22053391-microsoft-backoffice-sql-server-2000-developer-edition-shopping.htm

Creating Linked Servers

I'm new to this aspect of SQL Server so bear with me here. I have 2 SQL Servers (2000) in seperate locations on separate IPs. From what I'm reading and from what I've tried using Enterprise manager, the only way I can link the other server is by using the IP address as the name. Is there a way that I can specify a "user-friendly" name which will be used to reference tables on the linked server in queries?

This is the first time I've run across something that none of my books, nor the books online seem very clear about. Keep that in mind when replying, please. I may need the remedial course for this. <grin>

Any help is appreciated.

Thanks.On the machine that you will be registrying the Linked Servers, if you can not ping the SQL Server name of the other 2 ?

c:\> ping MyServer

But you can ping the IP addresses

c:\> ping xxx.xxx.xxx.xxx

Then you can create "user friendly" names 2 ways.

1) Add the 2 servers to the LMHOST file of the server or
2) Us SQL Server Client Network Utility to define Alias for these 2 servers.

The second method is the easiest since it is straight forward and you are using SQL Server tools. The first way is more of a global definition, that defines an alias that can be used by all commands and tools (ie net use). Where as the second method is strickly SQL Server realm.

Make sure that you use TCP/IP as your Network Library when defining the aliases (method 2).

Creating linked server to Sybase IQ

I would like to create a linked server from SQL Server to Sybase IQ. I have created linked servers before so I know how to do that. However, I dont know the specifics of creating a linked server to Sybase IQ.

What are the parameters that are necessary to link IQ to SQL Server. Which Provider do I use? Do I need to install a special driver?I found this for you : http://www.databasejournal.com/features/mssql/article.php/1756161

Hope that helps!|||Thanks for the reply but I actually already went to that website and tried that but it didnt work.

Creating Linked Server into Oracle

Hi Folks,
Pretty new to linked servers, however I need to create a linked server from
MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I alread
y
have successfull DTS application which takes info from the Oracle database
into MS SQL, using third party Oracle driver via DSN entry. I'm now need to
created a linked server into Oracle, have succesfull created link servers
between MS SQL servers but NOT between MS SQL and Oracle. I have checked the
web but finding it hard to come across good instructions. I would appreciate
if anyone can point me to a good web sites or instructions. Can I use my
third party driver(DSN) in creating a linked server?
thanks,
liamoActually, I'm a newbie at it and creating the linked server for Oracle was
really easy. Just go to Server Objects, Linked Servers in SQL Server
management Studio, right click on Linked Servers, pick New Linked Server and
populate the dialog when it comes up. You'll want to use the MSDAORA
provider. My provider string looks like:
Provider=MSDAORA;Data Source=zzzzzz.world;User ID=xxxxxx;Password=yyyyyyy
(substitute appropriate values). zzzzz.world goes into Product name field
in my case. Done!
Randall Arnold
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:577A3DAE-9EE3-4CEA-91F4-CADFA442FFF4@.microsoft.com...
> Hi Folks,
> Pretty new to linked servers, however I need to create a linked server
> from
> MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I
> already
> have successfull DTS application which takes info from the Oracle database
> into MS SQL, using third party Oracle driver via DSN entry. I'm now need
> to
> created a linked server into Oracle, have succesfull created link servers
> between MS SQL servers but NOT between MS SQL and Oracle. I have checked
> the
> web but finding it hard to come across good instructions. I would
> appreciate
> if anyone can point me to a good web sites or instructions. Can I use my
> third party driver(DSN) in creating a linked server?
> thanks,
> liamo

Creating Linked Server into Oracle

Hi Folks,
Pretty new to linked servers, however I need to create a linked server from
MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I already
have successfull DTS application which takes info from the Oracle database
into MS SQL, using third party Oracle driver via DSN entry. I'm now need to
created a linked server into Oracle, have succesfull created link servers
between MS SQL servers but NOT between MS SQL and Oracle. I have checked the
web but finding it hard to come across good instructions. I would appreciate
if anyone can point me to a good web sites or instructions. Can I use my
third party driver(DSN) in creating a linked server?
thanks,
liamo
Actually, I'm a newbie at it and creating the linked server for Oracle was
really easy. Just go to Server Objects, Linked Servers in SQL Server
management Studio, right click on Linked Servers, pick New Linked Server and
populate the dialog when it comes up. You'll want to use the MSDAORA
provider. My provider string looks like:
Provider=MSDAORA;Data Source=zzzzzz.world;User ID=xxxxxx;Password=yyyyyyy
(substitute appropriate values). zzzzz.world goes into Product name field
in my case. Done!
Randall Arnold
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:577A3DAE-9EE3-4CEA-91F4-CADFA442FFF4@.microsoft.com...
> Hi Folks,
> Pretty new to linked servers, however I need to create a linked server
> from
> MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I
> already
> have successfull DTS application which takes info from the Oracle database
> into MS SQL, using third party Oracle driver via DSN entry. I'm now need
> to
> created a linked server into Oracle, have succesfull created link servers
> between MS SQL servers but NOT between MS SQL and Oracle. I have checked
> the
> web but finding it hard to come across good instructions. I would
> appreciate
> if anyone can point me to a good web sites or instructions. Can I use my
> third party driver(DSN) in creating a linked server?
> thanks,
> liamo

Creating Linked Server into Oracle

Hi Folks,
Pretty new to linked servers, however I need to create a linked server from
MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I already
have successfull DTS application which takes info from the Oracle database
into MS SQL, using third party Oracle driver via DSN entry. I'm now need to
created a linked server into Oracle, have succesfull created link servers
between MS SQL servers but NOT between MS SQL and Oracle. I have checked the
web but finding it hard to come across good instructions. I would appreciate
if anyone can point me to a good web sites or instructions. Can I use my
third party driver(DSN) in creating a linked server?
thanks,
liamoActually, I'm a newbie at it and creating the linked server for Oracle was
really easy. Just go to Server Objects, Linked Servers in SQL Server
management Studio, right click on Linked Servers, pick New Linked Server and
populate the dialog when it comes up. You'll want to use the MSDAORA
provider. My provider string looks like:
Provider=MSDAORA;Data Source=zzzzzz.world;User ID=xxxxxx;Password=yyyyyyy
(substitute appropriate values). zzzzz.world goes into Product name field
in my case. Done!
Randall Arnold
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:577A3DAE-9EE3-4CEA-91F4-CADFA442FFF4@.microsoft.com...
> Hi Folks,
> Pretty new to linked servers, however I need to create a linked server
> from
> MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I
> already
> have successfull DTS application which takes info from the Oracle database
> into MS SQL, using third party Oracle driver via DSN entry. I'm now need
> to
> created a linked server into Oracle, have succesfull created link servers
> between MS SQL servers but NOT between MS SQL and Oracle. I have checked
> the
> web but finding it hard to come across good instructions. I would
> appreciate
> if anyone can point me to a good web sites or instructions. Can I use my
> third party driver(DSN) in creating a linked server?
> thanks,
> liamo

Creating Linked Server

Hello there
On my enterprise manager there are many Servers who are registered
I would like to transfare data between these two servers
When i'm conneted to one server on the query analyser and i'm trying to see
table from other server i get an error: Could not find server 'ROY-XP' in
sysservers. Execute sp_addlinkedserver to add the server to sysservers.
What i need to do in order to connect between these two servers?Roy
You can use EM to create linked server. Just provide a login and password
that can access the database.
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:eaj6jZa9FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Hello there
> On my enterprise manager there are many Servers who are registered
> I would like to transfare data between these two servers
> When i'm conneted to one server on the query analyser and i'm trying to
> see table from other server i get an error: Could not find server 'ROY-XP'
> in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
> What i need to do in order to connect between these two servers?
>
>|||Hi,
sp_addlinkedserver -- map server with this
and
sp_addlinkedsrvlogin -- map user account with this
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Roy Goldhammer" wrote:

> Hello there
> On my enterprise manager there are many Servers who are registered
> I would like to transfare data between these two servers
> When i'm conneted to one server on the query analyser and i'm trying to se
e
> table from other server i get an error: Could not find server 'ROY-XP' in
> sysservers. Execute sp_addlinkedserver to add the server to sysservers.
> What i need to do in order to connect between these two servers?
>
>