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 SQL2000 Database from SQL7 Database

I'm trying to create a new database on a SQL2000 server
from an existing one in a SQL7 server. If I dettach/attach
database or restore from an existing backup, I have this
error message:
"Microsoft SQL-DMO (ODBC SQLState:HY000)
Error 3624:
Location: xdes.cpp:1060
Expression: (m_state==XDES_ACTIVE_NOLOG)||IS_ON_SAFE
(XDES_OUTCOME_ONLY, m_status)||(IS_ON_SAFE
(XDES_BEGINXACT_LOGGED, m_status)&&(m_beginLsn!=NullLSN)&&
(m_lastLsn!=NullLSN))
SPID: 53
Process ID: 1064"
What can I do?Suggest running DBCC CHECKDB on the source database to ensure there is no
corruption.
Also check these resources :-
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b317852
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b283899
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b274266
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b324630
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b319212
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b295039
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b281220
HTH
Ryan Waight, MCDBA, MCSE
"Susana Pimentel" <spimentel@.aeportugal.com> wrote in message
news:0c3201c38f27$8f687530$a401280a@.phx.gbl...
> I'm trying to create a new database on a SQL2000 server
> from an existing one in a SQL7 server. If I dettach/attach
> database or restore from an existing backup, I have this
> error message:
> "Microsoft SQL-DMO (ODBC SQLState:HY000)
> Error 3624:
> Location: xdes.cpp:1060
> Expression: (m_state==XDES_ACTIVE_NOLOG)||IS_ON_SAFE
> (XDES_OUTCOME_ONLY, m_status)||(IS_ON_SAFE
> (XDES_BEGINXACT_LOGGED, m_status)&&(m_beginLsn!=NullLSN)&&
> (m_lastLsn!=NullLSN))
> SPID: 53
> Process ID: 1064"
> What can I do?

Creating database from backup?

Hi genius minds,
Suppose I have database backup file.
Can I create a new database(different than the database whose backup it is) and restore the backup into newly created database.
I'm having a backup file of some database, I want to create database from it. Suggest any way to do it?
ThxThat's the way to do it. Just be sure when you restore it, you give it a new database name and make sure the option to 'Force restore over existing database' is not turned on. You don't have to create the database first; it'll create it for you with the name you provide.

If you are restoring to a different server, you'll probably have to run sp_change_users_login to adjust the logins. If restoring to the same server, you won't have to.|||I have to restore it to a different server. I have all the login/passwords of both servers.
Can u gimme details of this sp_change_users_login?
Thx for ur reply|||Books on Line has all the details.|||Got it!
Thx for your help mate!