Restore database file with difference name

I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the
database to a file and I'll like to copy that file to another SQL 2000
Server and restore it with a difference name. what is the procedures and
how to go about doing it. I did tried to restore but getting the error:
Exclusive access could not be obtained because the database is in use.
Thanks in advance.
Hi,
You have to use RESTORE DATABASE with MOVE option.
Eg:-
Restore database <new_dbname> from disk='c;\backup\dbname.bak'
with move 'logical_data_filename' to 'physical_data_filename',
move 'logical_log_filename' to 'physical_log_filename', stats=10
Thanks
Hari
SQL Server MVP
"toby one" <support@.re.com> wrote in message
news:%23ee8Dq6ZFHA.3488@.tk2msftngp13.phx.gbl...
>I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the
> database to a file and I'll like to copy that file to another SQL 2000
> Server and restore it with a difference name. what is the procedures and
> how to go about doing it. I did tried to restore but getting the error:
> Exclusive access could not be obtained because the database is in use.
> Thanks in advance.
>
|||Seems like you want to overwrite an existing database with the overwrite
function in "Restore Database", try specifyin another name and perhpas
change the file locations the data will be restored in. If you make a
restore in the EM, the GUI will read the original destination of the data
and log files. If they already exists and error is thrown, if the directory
doesnt exists you have to create it first.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"toby one" <support@.re.com> schrieb im Newsbeitrag
news:%23ee8Dq6ZFHA.3488@.tk2msftngp13.phx.gbl...
>I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the
> database to a file and I'll like to copy that file to another SQL 2000
> Server and restore it with a difference name. what is the procedures and
> how to go about doing it. I did tried to restore but getting the error:
> Exclusive access could not be obtained because the database is in use.
> Thanks in advance.
>
|||There's nothing special here. Do the backup, copy the backup file and then do the restore,
specifying the desired database name and possibly using the MOVE option to specify the desired
physical filenames. See the BACKUP DATABASE and RESTORE DATABASE commands in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"toby one" <support@.re.com> wrote in message news:%23ee8Dq6ZFHA.3488@.tk2msftngp13.phx.gbl...
>I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the
> database to a file and I'll like to copy that file to another SQL 2000
> Server and restore it with a difference name. what is the procedures and
> how to go about doing it. I did tried to restore but getting the error:
> Exclusive access could not be obtained because the database is in use.
> Thanks in advance.
>
sql

Restore database file with difference name

I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the
database to a file and I'll like to copy that file to another SQL 2000
Server and restore it with a difference name. what is the procedures and
how to go about doing it. I did tried to restore but getting the error:
Exclusive access could not be obtained because the database is in use.
Thanks in advance.Hi,
You have to use RESTORE DATABASE with MOVE option.
Eg:-
Restore database <new_dbname> from disk='c;\backup\dbname.bak'
with move 'logical_data_filename' to 'physical_data_filename',
move 'logical_log_filename' to 'physical_log_filename', stats=10
Thanks
Hari
SQL Server MVP
"toby one" <support@.re.com> wrote in message
news:%23ee8Dq6ZFHA.3488@.tk2msftngp13.phx.gbl...
>I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the
> database to a file and I'll like to copy that file to another SQL 2000
> Server and restore it with a difference name. what is the procedures and
> how to go about doing it. I did tried to restore but getting the error:
> Exclusive access could not be obtained because the database is in use.
> Thanks in advance.
>|||Seems like you want to overwrite an existing database with the overwrite
function in "Restore Database", try specifyin another name and perhpas
change the file locations the data will be restored in. If you make a
restore in the EM, the GUI will read the original destination of the data
and log files. If they already exists and error is thrown, if the directory
doesnt exists you have to create it first.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"toby one" <support@.re.com> schrieb im Newsbeitrag
news:%23ee8Dq6ZFHA.3488@.tk2msftngp13.phx.gbl...
>I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the
> database to a file and I'll like to copy that file to another SQL 2000
> Server and restore it with a difference name. what is the procedures and
> how to go about doing it. I did tried to restore but getting the error:
> Exclusive access could not be obtained because the database is in use.
> Thanks in advance.
>|||There's nothing special here. Do the backup, copy the backup file and then d
o the restore,
specifying the desired database name and possibly using the MOVE option to s
pecify the desired
physical filenames. See the BACKUP DATABASE and RESTORE DATABASE commands in
Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"toby one" <support@.re.com> wrote in message news:%23ee8Dq6ZFHA.3488@.tk2msftngp13.phx.gbl...

>I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the
> database to a file and I'll like to copy that file to another SQL 2000
> Server and restore it with a difference name. what is the procedures and
> how to go about doing it. I did tried to restore but getting the error:
> Exclusive access could not be obtained because the database is in use.
> Thanks in advance.
>

Restore Database Fails

I'm trying to use ADO to restore a SQL 7 database using a backup file. The
database already exists on the target computer, and is named the same as on
the source computer, and the MDF and LDF files are named the same as well.

I am running the below in a stored procedure:

RESTORE DATABASE DB1
FROM DISK = 'c:\mssql7\backup\DB1.bak'
WITH MOVE 'DB1' TO 'c:\mssql7\data\DB1.mdf',
MOVE 'DB1_log' TO 'c:\mssql7\data\DB1_log.ldf'

And I get an error message "File 'DB1' is not a database file for database
'DB1' ".

I also tried it without the LDF file in the expression. Same results.

Thanks.Neil (nospam@.nospam.net) writes:

Quote:

Originally Posted by

I'm trying to use ADO to restore a SQL 7 database using a backup file.
The database already exists on the target computer, and is named the
same as on the source computer, and the MDF and LDF files are named the
same as well.
>
I am running the below in a stored procedure:
>
RESTORE DATABASE DB1
FROM DISK = 'c:\mssql7\backup\DB1.bak'
WITH MOVE 'DB1' TO 'c:\mssql7\data\DB1.mdf',
MOVE 'DB1_log' TO 'c:\mssql7\data\DB1_log.ldf'
>
And I get an error message "File 'DB1' is not a database file for database
'DB1' ".

Add ", REPLACE" to your command.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||OK, replaced the original command with:

RESTORE DATABASE DB1
FROM DISK = 'c:\mssql7\backup\DB1.bak'
WITH MOVE DB1 TO 'c:\mssql7\data\DB1.mdf',
MOVE DB1_log' TO 'c:\mssql7\data\DB1_log.ldf',
REPLACE

Got the same error message.

"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns9945EC53F9A4BYazorman@.127.0.0.1...

Quote:

Originally Posted by

Neil (nospam@.nospam.net) writes:

Quote:

Originally Posted by

>I'm trying to use ADO to restore a SQL 7 database using a backup file.
>The database already exists on the target computer, and is named the
>same as on the source computer, and the MDF and LDF files are named the
>same as well.
>>
>I am running the below in a stored procedure:
>>
>RESTORE DATABASE DB1
>FROM DISK = 'c:\mssql7\backup\DB1.bak'
>WITH MOVE 'DB1' TO 'c:\mssql7\data\DB1.mdf',
>MOVE 'DB1_log' TO 'c:\mssql7\data\DB1_log.ldf'
>>
>And I get an error message "File 'DB1' is not a database file for
>database
>'DB1' ".

>
Add ", REPLACE" to your command.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||As a followup to my previous message, I also tried the modified command
directly from Query Analyzer, and got the same message. I then tried to
restore the backup file from Enterprise Manager, and it worked fine. But
couldn't get the SQL to work.

However, I still need to get it to work, as I have an associate who needs to
restore the same backup set, but he doesn't have QA or EM. He's running the
SQL in a stored procedure using ADO.

Thanks,

Neil

"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns9945EC53F9A4BYazorman@.127.0.0.1...

Quote:

Originally Posted by

Neil (nospam@.nospam.net) writes:

Quote:

Originally Posted by

>I'm trying to use ADO to restore a SQL 7 database using a backup file.
>The database already exists on the target computer, and is named the
>same as on the source computer, and the MDF and LDF files are named the
>same as well.
>>
>I am running the below in a stored procedure:
>>
>RESTORE DATABASE DB1
>FROM DISK = 'c:\mssql7\backup\DB1.bak'
>WITH MOVE 'DB1' TO 'c:\mssql7\data\DB1.mdf',
>MOVE 'DB1_log' TO 'c:\mssql7\data\DB1_log.ldf'
>>
>And I get an error message "File 'DB1' is not a database file for
>database
>'DB1' ".

>
Add ", REPLACE" to your command.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||OK, I got it to work. Seems I was using MOVE to move the MDF and LDF to
those locations; but the MDF and LDF for the database that was being
overwritten were already at those locations. So I removed the MOVE commands,
and it worked fine. The final version was:

RESTORE DATABASE DB1
FROM DISK = 'c:\mssql7\backup\DB1.bak'
WITH RESTORE

Thanks!

Neil

"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns9945EC53F9A4BYazorman@.127.0.0.1...

Quote:

Originally Posted by

Neil (nospam@.nospam.net) writes:

Quote:

Originally Posted by

>I'm trying to use ADO to restore a SQL 7 database using a backup file.
>The database already exists on the target computer, and is named the
>same as on the source computer, and the MDF and LDF files are named the
>same as well.
>>
>I am running the below in a stored procedure:
>>
>RESTORE DATABASE DB1
>FROM DISK = 'c:\mssql7\backup\DB1.bak'
>WITH MOVE 'DB1' TO 'c:\mssql7\data\DB1.mdf',
>MOVE 'DB1_log' TO 'c:\mssql7\data\DB1_log.ldf'
>>
>And I get an error message "File 'DB1' is not a database file for
>database
>'DB1' ".

>
Add ", REPLACE" to your command.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||Neil (nospam@.nospam.net) writes:

Quote:

Originally Posted by

OK, replaced the original command with:
>
RESTORE DATABASE DB1
FROM DISK = 'c:\mssql7\backup\DB1.bak'
WITH MOVE DB1 TO 'c:\mssql7\data\DB1.mdf',
MOVE DB1_log' TO 'c:\mssql7\data\DB1_log.ldf',
REPLACE
>
Got the same error message.

The the problem is that the logical names of the files are not DB1 and
DB1_log. You can retrieve these names with RESTORE FILELISTONLY.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

restore database

I have a copy of a backup from a user site. a .sbk file..
I have a development server at my work site and an old copy of the
database that I use for testing. I would like to overlay my old copy of
the database with the backup from the user site. What is the best way
to do this?
Thanks
See the RESTORE DATABASE topic in Books Online. To overwrite the old copy,
just specify the same name and the REPLACE options, along with all the other
requried items...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"terry" <cooleyt@.woh.rr.com> wrote in message
news:phaaf.179542$lI5.158808@.tornado.ohiordc.rr.co m...
>I have a copy of a backup from a user site. a .sbk file..
> I have a development server at my work site and an old copy of the
> database that I use for testing. I would like to overlay my old copy of
> the database with the backup from the user site. What is the best way to
> do this?
> Thanks
>
|||here are the steps I am taking to do the restore
step 1
Restore filelistonly
from disk = c:\projects\\lams.sdk
this produces a table with
logical filename = hrattend_data physical name =
f:\sqldata\\hrattend.mdf
logical filename = hrattend_log physical name = f:\sqldata\\hrattend.ldf
step 2
restore database hrattend
from disk = c:\projects\..\lams.sdk
with
move hrattend_data to c:\program files\\hrattend.mdf,
move hrattend_log to c:\program files\..\hrattend.ldf,
replace,
stats = 10
the data is still the old data.
my question is following the restore filelistonly, why does the physical
name fields reference f:\ ? shouldn't this be in c:\ where the backup
is located?
|||> the data is still the old data.
Do RESTORE HEADERONLY. You might have several backups on that file and you are restorring the oldest
one. Use the FILE option to specify anything else than the first (1).

> my question is following the restore filelistonly, why does the physical name fields reference f:\
> ?
Where do you see this physical name field?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"terry" <cooleyt@.woh.rr.com> wrote in message news:Rbdaf.181702$lI5.74710@.tornado.ohiordc.rr.com ...
> here are the steps I am taking to do the restore
> step 1
> Restore filelistonly
> from disk = c:\projects\\lams.sdk
> this produces a table with
> logical filename = hrattend_data physical name = f:\sqldata\\hrattend.mdf
> logical filename = hrattend_log physical name = f:\sqldata\\hrattend.ldf
> step 2
> restore database hrattend
> from disk = c:\projects\..\lams.sdk
> with
> move hrattend_data to c:\program files\\hrattend.mdf,
> move hrattend_log to c:\program files\..\hrattend.ldf,
> replace,
> stats = 10
> the data is still the old data.
> my question is following the restore filelistonly, why does the physical name fields reference f:\
> ? shouldn't this be in c:\ where the backup is located?
>
>
|||Hi,
Physical name field is the actual place your MDF and LDF were stored when
you backup the source database. Based on that
you can decide whether you need a MOVE command or not. Incase if you have
same folder in destination server then you do not want to
give a MOVE command; else you have mention move command to redirect the MDF
and LDF to a new path.
The other question:- As Tibor mentioned use RESTORE HEADERONLY command to
find the latest backup file and use FILE = 'latest number'
in your RESTORE DATABASE command.
Thanks
Hari
SQL server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e%23PXQcE4FHA.252@.TK2MSFTNGP15.phx.gbl...
> Do RESTORE HEADERONLY. You might have several backups on that file and you
> are restorring the oldest one. Use the FILE option to specify anything
> else than the first (1).
>
> Where do you see this physical name field?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "terry" <cooleyt@.woh.rr.com> wrote in message
> news:Rbdaf.181702$lI5.74710@.tornado.ohiordc.rr.com ...
>
|||terry wrote:
> here are the steps I am taking to do the restore
> step 1
> Restore filelistonly
> from disk = c:\projects\\lams.sdk
> this produces a table with
> logical filename = hrattend_data physical name =
> f:\sqldata\\hrattend.mdf
> logical filename = hrattend_log physical name = f:\sqldata\\hrattend.ldf
> step 2
> restore database hrattend
> from disk = c:\projects\..\lams.sdk
> with
> move hrattend_data to c:\program files\\hrattend.mdf,
> move hrattend_log to c:\program files\..\hrattend.ldf,
> replace,
> stats = 10
> the data is still the old data.
> my question is following the restore filelistonly, why does the physical
> name fields reference f:\ ? shouldn't this be in c:\ where the backup
> is located?
>
>
The physical name in the RESTORE FILELISTONLY, refers to the original
location of the files. This is info that is stored in the backup file
and isn't related to anything on your server.
If you want to overwrite your existing database, you don't have to use
the MOVE option. Basically you just run -
RESTORE DATABASE hrattend FROM DISK = 'c:\projects\...\lams.sdk'
WITH RECOVERY, REPLACE, STATS =10
HTH
Regards
Steen
|||this did not work as expected. The backup file that I am using was
created on 11/02. I previously restored the database in Jun. The new
back up file is larger than the previous one, so I am assuming that it
contains more records. Following the restore, my tables still only
contain records ending in June.
I tried to create a new database from the 11/02 backup using the Restore
function in the enterprise manager. I successfully created a new
database, but it still only contains records up to Jun. What am I missing?
|||I finally figured it out. Thanks for the help...
The restore headeronly set me off in the right direction. There were
three backup sets in the backup file. They neglected to tell me that.

restore database

I have a copy of a backup from a user site. a .sbk file..
I have a development server at my work site and an old copy of the
database that I use for testing. I would like to overlay my old copy of
the database with the backup from the user site. What is the best way
to do this?
ThanksSee the RESTORE DATABASE topic in Books Online. To overwrite the old copy,
just specify the same name and the REPLACE options, along with all the other
requried items...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"terry" <cooleyt@.woh.rr.com> wrote in message
news:phaaf.179542$lI5.158808@.tornado.ohiordc.rr.com...
>I have a copy of a backup from a user site. a .sbk file..
> I have a development server at my work site and an old copy of the
> database that I use for testing. I would like to overlay my old copy of
> the database with the backup from the user site. What is the best way to
> do this?
> Thanks
>|||here are the steps I am taking to do the restore
step 1
Restore filelistonly
from disk = c:\projects\\lams.sdk
this produces a table with
logical filename = hrattend_data physical name =
f:\sqldata\\hrattend.mdf
logical filename = hrattend_log physical name = f:\sqldata\\hrattend.ldf
step 2
restore database hrattend
from disk = c:\projects\..\lams.sdk
with
move hrattend_data to c:\program files\\hrattend.mdf,
move hrattend_log to c:\program files\..\hrattend.ldf,
replace,
stats = 10
the data is still the old data.
my question is following the restore filelistonly, why does the physical
name fields reference f:\ ? shouldn't this be in c:\ where the backup
is located?|||> the data is still the old data.
Do RESTORE HEADERONLY. You might have several backups on that file and you a
re restorring the oldest
one. Use the FILE option to specify anything else than the first (1).

> my question is following the restore filelistonly, why does the physical n
ame fields reference f:\
> ?
Where do you see this physical name field?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"terry" <cooleyt@.woh.rr.com> wrote in message news:Rbdaf.181702$lI5.74710@.tornado.ohiordc.rr
.com...
> here are the steps I am taking to do the restore
> step 1
> Restore filelistonly
> from disk = c:\projects\\lams.sdk
> this produces a table with
> logical filename = hrattend_data physical name = f:\sqldata\\hrattend
.mdf
> logical filename = hrattend_log physical name = f:\sqldata\\hrattend.ld
f
> step 2
> restore database hrattend
> from disk = c:\projects\..\lams.sdk
> with
> move hrattend_data to c:\program files\\hrattend.mdf,
> move hrattend_log to c:\program files\..\hrattend.ldf,
> replace,
> stats = 10
> the data is still the old data.
> my question is following the restore filelistonly, why does the physical n
ame fields reference f:\
> ? shouldn't this be in c:\ where the backup is located?
>
>|||Hi,
Physical name field is the actual place your MDF and LDF were stored when
you backup the source database. Based on that
you can decide whether you need a MOVE command or not. Incase if you have
same folder in destination server then you do not want to
give a MOVE command; else you have mention move command to redirect the MDF
and LDF to a new path.
The other question:- As Tibor mentioned use RESTORE HEADERONLY command to
find the latest backup file and use FILE = 'latest number'
in your RESTORE DATABASE command.
Thanks
Hari
SQL server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e%23PXQcE4FHA.252@.TK2MSFTNGP15.phx.gbl...
> Do RESTORE HEADERONLY. You might have several backups on that file and you
> are restorring the oldest one. Use the FILE option to specify anything
> else than the first (1).
>
> Where do you see this physical name field?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "terry" <cooleyt@.woh.rr.com> wrote in message
> news:Rbdaf.181702$lI5.74710@.tornado.ohiordc.rr.com...
>|||terry wrote:
> here are the steps I am taking to do the restore
> step 1
> Restore filelistonly
> from disk = c:\projects\\lams.sdk
> this produces a table with
> logical filename = hrattend_data physical name =
> f:\sqldata\\hrattend.mdf
> logical filename = hrattend_log physical name = f:\sqldata\\hrattend.ld
f
> step 2
> restore database hrattend
> from disk = c:\projects\..\lams.sdk
> with
> move hrattend_data to c:\program files\\hrattend.mdf,
> move hrattend_log to c:\program files\..\hrattend.ldf,
> replace,
> stats = 10
> the data is still the old data.
> my question is following the restore filelistonly, why does the physical
> name fields reference f:\ ? shouldn't this be in c:\ where the backup
> is located?
>
>
The physical name in the RESTORE FILELISTONLY, refers to the original
location of the files. This is info that is stored in the backup file
and isn't related to anything on your server.
If you want to overwrite your existing database, you don't have to use
the MOVE option. Basically you just run -
RESTORE DATABASE hrattend FROM DISK = 'c:\projects\...\lams.sdk'
WITH RECOVERY, REPLACE, STATS =10
HTH
Regards
Steen|||this did not work as expected. The backup file that I am using was
created on 11/02. I previously restored the database in Jun. The new
back up file is larger than the previous one, so I am assuming that it
contains more records. Following the restore, my tables still only
contain records ending in June.
I tried to create a new database from the 11/02 backup using the Restore
function in the enterprise manager. I successfully created a new
database, but it still only contains records up to Jun. What am I missing?|||I finally figured it out. Thanks for the help...
The restore headeronly set me off in the right direction. There were
three backup sets in the backup file. They neglected to tell me that.

Restore a backup to a database using SQLDMO

Hai...
I am working on VC++. I need to restore the backup to the
database(SQL SERVER) using SQLDMO in VC++. I am able to restore the
backup only to the database where i taken the backup but to some other
database it fails. Can anyone provide me the solution for restoring the
backup to some other database? Looking for the reply...
Thanx in advance...
Regards,
PrinceYou need to set the Backup object ReplaceDatabase property to TRUE. From
the Books Online:
<Excerpt href="http://links.10026.com/?link=sqldmo.chm::/dmoref_p_r_1cop.htm">
If TRUE, a new image of the database is created. The image is created
regardless of the presence of an existing database with the same name.
If FALSE (default), a new image of the database is not created by the
restore operation. The database targeted by the restore operation must exist
on an instance of Microsoft SQL ServerT 2000.
</Excerpt>
Hope this helps.
Dan Guzman
SQL Server MVP
"Prince" <princevictor.moses@.gmail.com> wrote in message
news:1124188828.330558.78130@.z14g2000cwz.googlegroups.com...
> Hai...
> I am working on VC++. I need to restore the backup to the
> database(SQL SERVER) using SQLDMO in VC++. I am able to restore the
> backup only to the database where i taken the backup but to some other
> database it fails. Can anyone provide me the solution for restoring the
> backup to some other database? Looking for the reply...
> Thanx in advance...
> Regards,
> Prince
>